Forum Discussion

WFS's avatar
WFS
Regular Visitor
7 years ago
Solved

get data from azure sql - why do i need data gateway???

Hi, i am trying to get data from Azure SQL.  for some reason in the PBI service 'Get Data' page it says that this data source is available only in PBI Desktop. q1: why getting data from Azure SQL ...
Need Help
  • pbiadvisor's avatar
    pbiadvisor
    7 years ago

    So actually, even though the Desktop complains about a gateway, you can go to the dataset in the service and just update the dataset credentials and it will connect and you can view your report.  Refer to this page: https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery

    Until credentials are supplied, opening a published report or exploring a dataset created with a DirectQuery connection to such data sources results in an error.

    For data sources other than Azure SQL Database, Azure SQL Data Warehouse and Redshift that use DirectQuery, an On-premises data gateway must be installed and the data source must be registered to establish a data connection. You can learn more about On-premises data gateway.

    I did this, and it worked for me.

pbiadvisor's avatar
pbiadvisor
New Member
7 years ago

So actually, even though the Desktop complains about a gateway, you can go to the dataset in the service and just update the dataset credentials and it will connect and you can view your report.  Refer to this page: https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery

Until credentials are supplied, opening a published report or exploring a dataset created with a DirectQuery connection to such data sources results in an error.

For data sources other than Azure SQL Database, Azure SQL Data Warehouse and Redshift that use DirectQuery, an On-premises data gateway must be installed and the data source must be registered to establish a data connection. You can learn more about On-premises data gateway.

I did this, and it worked for me.

pbiadvisor's avatar
pbiadvisor
New Member
7 years ago

As far as why the Azure SQL Database wasnt appearing in the Service:

In order to connect to Azure SQL Database using DirectQuery, you will need to use Power BI Desktop. This approach provides additional flexibility and capabilities. Reports created using Power BI Desktop can then be published to the Power BI service. You can learn more about how to connect to Azure SQL Database using DirectQuery within Power BI Desktop.

Taken from here: https://docs.microsoft.com/en-us/power-bi/service-azure-sql-database-with-direct-connect