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.
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.
followed your instructions and now it works.
thanks!!