Forum Discussion
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 is not available in the PBI Service? or am i missing something?
in the PBI desktop, when i try to get data from Azure SQL (direct query mode), all is good but then when i publish it says that 'the published report cant connect to the data source because we were unable to find a gateway..."
q2: why do i need a gateway for connecting to Azure SQL database?
then i download and install the gateway, restart the PBI Desktop, try to publish, and again getting the same message.
(note: PBI Desktop and gateway have been downloaded and installed on April 21st 2019).
when i go to PBI service i see the report but when i access it it is blank with some error message
q3: what am i missing here???
thanks for the help!
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.
6 Replies
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.
