Forum Discussion
Anonymous
6 years agoNot applicable
Unable to access data from Azure SQL Database in Power BI Service
Hi all, I was creating and publishing reports in power bi by connecting to Azure SQL Database instance. Due to security restrictions, we use VPN and created the reports in Power BI Desktop inside...
Icey
6 years agoCommunity Support
Hi Anonymous ,
1. Do you enable VPN to keep the connection?
If not, please enable VPN and try it again.
2. Was your Azure SQL Database set secure connection to Power BI Service?
If it was, I suggest you to use an Enterprise gateway, even the data source is in cloud.
The Power BI Gateway server runs on a private Azure VNet, and the SQL Server's firewall is configured to allow connections from this VNet.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.