Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello,
we are working on scenario for connectivity to PowerBI service and Azure SQL via Power Data Gateway for Power BI Desktop clients.
Can Power Bi Desktop client use Power Bi Data Gateway to connect to Azure SQL ?
Azure SQL connects with Power Bi Service Via PowerBI Data Gateway.
Azure AD connects with Power BI Service Via Power Bi Data Gateway.
Thanks
Prakash
Solved! Go to Solution.
Hi Prakash,
You can connect to Azure SQL directly without using the gateway.
You can also use a Power BI Data Gateway to connect to an Azure SQL server.
Gateway - Setup a Data Source that points to the Azure database. Select data source type as SQL Server.
Power BI - Create a report using the data source
Azure Portal - Confirm the IP address running the Data Gateway is opened up in the Azure Firewall if the report visuals don't display.
Good luck.
~Mansoor
Hi Prakash,
You can connect to Azure SQL directly without using the gateway.
You can also use a Power BI Data Gateway to connect to an Azure SQL server.
Gateway - Setup a Data Source that points to the Azure database. Select data source type as SQL Server.
Power BI - Create a report using the data source
Azure Portal - Confirm the IP address running the Data Gateway is opened up in the Azure Firewall if the report visuals don't display.
Good luck.
~Mansoor
Thank You Mansoor 🙏
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!