Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by watching the DP-600 session on-demand now through April 28th.
Learn moreJoin the FabCon + SQLCon recap series. Up next: Power BI, Real-Time Intelligence, IQ and AI, and Data Factory take center stage. All sessions are available on-demand after the live show. Register now
Hi Power BI forums!
We have set up an Azure SQL Server behind the private endpoint and denied all public network access for that server. Now I wanted to set up a personal gateway to enable auto-refresh in Power BI service - is this possible?
I saw that in Power BI service this connection is automatically marked as "cloud" connection but we can't really access the data source from the cloud, so I am wondering if it is possible to ask Power BI service to go with the gateway instead?
Thank you!
Hi @wcai
For this to run, you would need to use a vnet to access your sql server. There are details on how to do this.
Use virtual network data gateway and data sources in Power BI | Microsoft Learn
Thank you @GilbertQ
Is it possible to achieve this with personal gateway? Just like how we can access on-premise web api through personal gateway, is it possible to treat this SQL server as on-premise SQL server?
I am aware of vnet but it will take some time before our IT department to work on that
Hi @wcai
Unfortunately that is the only way to access it without opening up IP Addresses to the Power BI Service (Which from what I know is quite a lot and also change frequently)
Check out the April 2026 Power BI update to learn about new features.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
| User | Count |
|---|---|
| 9 | |
| 8 | |
| 8 | |
| 8 | |
| 7 |