Forum Discussion
Azure SQL Database Gateway
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
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
5 Replies
nagaraj , refer if this can help
https://radacad.com/power-bi-get-data-from-azure-sql-database
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
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
