Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have built a simple power bi desktop file with only one connection to our azure dw using direct query.
When I publish it, I get the following error message: [...]we are unable to find a gateway[...]
Then on the web, it says: we don't support settings for this dataset.
I thought azure didn't need a gateway.
Can you plese help?
Hi @Anonymous,
In Power BI, DirectQuery connection to Azure SQL Data Warehouse doesn't require any gateway, see: Databases in the cloud.
Also based on my test in Power BI desktop version 2.42.4611.901, if only one query exists in the .pbix file connect to Azure SQL data Warehouse, it will not prompt us to configure a gateway when we click Publish button. See:
In your scenario, please check if only one query which points to the Azure SQL Data Warehouse in the .pbix. You can open Query Editor. Also please check if only one data source in this file like below:
Best Regards,
Qiuyun Yu
Thanks @v-qiuyu-msft
My desktop version is the same as yours. The file has only query and one data source (the azure dw).
When I publish, I get this message:
Can you help?
Best,
Yann
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
48 | |
19 | |
13 | |
11 |