Azure SQL Database Gateway

[nagaraj]

Hi,

 Our report is pulling data from Azure SQL database, i am using Direct Query mode.

 Report is working fine, but when published report is asking for Gateway connection.

For Azure SQL database do we need to setup gateway for Azure databases.

Not sure please suggest the steps to resolve this

[v-xuding-msft · Accepted solution]

Hi @nagaraj ,

When using DirectQuery with an Azure SQL Database and a private IP address, an on-premises gateway is required.  You could reference the document: Important considerations when using DirectQuery  to learn more.

Please add the data source into gateway and map to it in dataset settings to try again.

For more details about gateways, please take a look at the documents.

On-premises data gateway in-depth 

[amitchandak]

@nagaraj , refer if this can help

https://radacad.com/power-bi-get-data-from-azure-sql-database

[nagaraj]

Hi @amitchandak @az38 

Thanks for your inputs, my azure database has all the permission that were mentioned in the belwo link.

Not sure what is the issue, to explain bit more 

 1. I have multiple datasources (SQL Server On Premise, Azure SQL database)

 2. In my report apart from 1 table all others are using IMPORT mode.

 3. Desktop the report is working fine.

 4. When published to Service i see the below error

 Error:  There is no available gateway

Regards

Nagaraj

[az38]

@nagaraj 

if you use On-Premises SQL Server, the Service will need access to it. Do you have a Gateway from Service to On-Premise?

[az38]

Hi @nagaraj 

check this manual https://docs.microsoft.com/en-us/power-bi/service-azure-sql-database-with-direct-connect