Forum Discussion
Post PatronAzure SQL Database Gateway
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
Post PatronHi 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
