Forum Discussion

wcai's avatar
wcai
New Member
2 years ago

Accessing SQL Server behind Private Endpoint?

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!

Need Help

3 Replies

    • wcai's avatar
      wcai
      New Member
      2 years ago

      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

      • GilbertQ's avatar
        GilbertQ
        Super User
        2 years ago

        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)