How Connect Powerbi with sql endpoint with no public access only private?

[juanchochuy]

 we are making configuration adjustments in the workspaces to disable public access. My concern is whether this will impact the Power BI dashboards that currently consume data from our workspace's SQL Data Warehouse.

[Kaniz_Fatma]

Hi @juanchochuy, Disabling public access in your workspace could potentially impact your Power BI dashboards that consume data from your SQL Data Warehouse, but it largely depends on how your Power BI is set up.

When you block public internet access, you can continue using Power BI, datasets, and pipelines, but.... This includes third-party application access to certain APIs.

Power BI allows you to explore and monitor data stored in your Azure SQL database directly, without .... You can create a connection to your source easily, either by providing the connection details in Pow....

However, private endpoints do not guarantee that traffic from Power BI to your external data sources.... You may need to configure firewall rules and virtual networks to further secure your data sources.

Before making any changes, it’s recommended to review the considerations and limitations of your spe.... 

Please let me know if you have any other questions! 😊

[gmiguel]

If you're using Azure Databricks, you can create a vnet data gateway on Azure.

https://learn.microsoft.com/en-us/data-integration/vnet/create-data-gateways

https://learn.microsoft.com/en-us/data-integration/vnet/high-availability-load-balancing

You need to create a subnet that will work as a gateway for pbi to access your Databricks Sql Warehouses.
The number of data gateways you create on PBI is related to the number of concurrency queries you can run in parallel.