PowerBI Service DirectQuery with Azure SQL server database

[mail2vajram]

Hello All,

I recently started working on PowerBI for an assignment.  I have a question with respect to Access to Azure SQL database from PowerBI service.

I have a requirement to make aceess to Azure SQL server database only to PowerBI service and not from any other internet sources. As I read in the documentation, we can implement this by using the  database firewall rules based on IP ranges. But my issue is that, how do I Know the PowerBI IP address ranges.

Please also let me know, if any alternative approach can be used to implement this.

[v-jiascu-msft]

Hi @mail2vajram,

Could you please mark the proper answer as the solution?

Best Regards,

Dale

[v-jiascu-msft · Accepted solution]

Hi @mail2vajram,

Since Power BI Service is one kind of Azure Services, we can allow the access to Azure with one simple configuration. Please refer to sql-database/sql-database-vnet-service-endpoint-rule-overview#benefits-of-a-virtual-network-rule.

Best Regards,

Dale