Forum Discussion
get data from azure sql - why do i need data gateway???
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.
Are you connecting live or is this import?
Hi Greg,
thanks for the quick reply.
i am using DirectQuery for the data conectivity mode.
I am seeing the same error. Just updated the desktop to April 2019 and tried this.
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.
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