Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I am trying to connect to an SQL database in Azure Synapse using a virtual private endpoint. The virtual private endpoint has been setup as well as the connector and both are online. Previously, I was able to see the tables via a dataflow using this connector. However, when I try this now, I'm unable to see or select the connector or data gateway in the dataflow creation pane. Does anyone know a solution to this problem?
Thanks in advance!
(server and database are blurred)
Solved! Go to Solution.
Hi @yourih - Ensure that your Data Gateway is properly configured for private endpoints, as it plays a critical role in securely routing your queries from Power BI to your Azure SQL Database. Even though you're using a private endpoint, the on-premises gateway may still be required, especially if you're using specific network configurations.
Gateway
What is a private endpoint? - Azure Private Link | Microsoft Learn
Troubleshoot the on-premises data gateway | Microsoft Learn
Proud to be a Super User! | |
Hi @yourih - Ensure that your Data Gateway is properly configured for private endpoints, as it plays a critical role in securely routing your queries from Power BI to your Azure SQL Database. Even though you're using a private endpoint, the on-premises gateway may still be required, especially if you're using specific network configurations.
Gateway
What is a private endpoint? - Azure Private Link | Microsoft Learn
Troubleshoot the on-premises data gateway | Microsoft Learn
Proud to be a Super User! | |