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.
