Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have one data source in my model which stored in the cloud - SQL Server managed instance.
Do I really have to use a gateway?
Solved! Go to Solution.
Hi Snir_Shaked,
Based on my research, I find that you might not need to use gateway. For previous year’s post , we could see PG said that “At the moment, gateway is needed for PowerBI Online to access Azure SQL Managed Instance residing in customer’s virtual network, just like with SQL Server on-premises.
I would also add that later this year Managed Instance is going to offer optional public endpoint, which will allow PowerBI Online to access it directly, without need for gateway, which will also unlock OAuth2 (AAD) authentication option”
You could refer to Configure public endpoint in Azure SQL Database managed instance and Azure SQL Server Managed Instance for details.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I am not able to connect to the azure sql managed instance directly without using gatway,
I don't want to use power bi on premise data gateway since it will make round trip to on-premise.
Also, not want to enable public end point as there will be security issue.
Is there any other workaround for this.
Thanks,
Pankaj
We're in the same boat. We have a SQL Managed Instance with a public endpoint enabled but the PowerBI service is saying we still require an on-premise gateway. Is there a way to update the PowerBI service so it uses the SQL Managed Instance public endpoint?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.