A client is concerned about opening access to a port in their Citrix application (where we access Power BI desktop and Power BI service) so that we can use import mode in our semantic model and connect to a Fabric SQL endpoint. The justification is it’s against standards to allow public traffic to SQL endpoints. they asked about setting up private endpoints but from what I have read that applies for setting up access for Fabric to pull data from another system’s endpoint. It isn’t for accessing Fabric’s SQL end point.
From research it sounds as though as long as you are logged in to Power BI desktop the connection to fabric items is secure and uses Microsoft’s backbone for all of it and this IS secure.
Does anyone have any good documentation on this or can explain it in a way that I can help the client understand. or know of a different solution?
Right now my team is able to create delta lake models on the lakehouse but can’t do anything with Import Mode because that uses the SQL endpoint and import mode is is part of our reporting requirements.