I'm currently using Power BI to connect with Azure SQL databases for reporting, and we have a firewall that only allows specific IP addresses. There's an option enabled for all Azure services to connect, which has worked fine. Now, we want to transition some of our reporting databases to Azure SQL Managed Instances and need to figure out how to let Power BI connect through our private network. What steps should I take to enable this connection, considering that Azure SQL Managed Instances have different firewall settings compared to standard Azure SQL databases?
1 Answer
To connect Power BI to your Azure SQL Managed Instance, you’ll need to set up a data gateway. Think of Managed Instances as more like SQL Server on a VM or on-premises from a network standpoint. This means the typical Azure SQL Database settings won’t completely apply. Check out this guide for integration tips! [Guide to Azure Integration](https://techcommunity.microsoft.com/blog/azuresqlblog/integrate-microsoft-cloud-services-with-your-azure-sql-database-managed-instance/1083543)
Thanks for the link! I was wondering, would enabling the public endpoint be a bad idea? We’ve considered it since we need external customers to connect and run their queries, but I'm concerned about security.