Power BI Data gateway for PowerBI desktop clients to connect azure SQL

[prakashmodak1]

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

[mansoorqureshi · Accepted 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.

1. Gateway - Setup a Data Source that points to the Azure database. Select data source type as SQL Server.

2. Power BI - Create a report using the data source

3. 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

[prakashmodak1]

Thank You Mansoor 🙏