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.
Direct Query is not working once I publish the report. I see following error. It used to work in June time frame. Please advise
Please help.
Make sure you configure your data source/s after you publish to PBIRS. Go to the ellipsis (...) on your report in PBIRS -> Manage ->Data sources and setup your server name/ auth type / credentials.
I've always had to go there and configure, even though it worked in the PBIRS Desktop before publishing.
MM
I have 2 PBI reports in using Desktop, connecting to Azure SQL DB
1. ImportQuery - Azure SQL DB
2. DirectQuery - Azure SQL DB
I got Power BI Pro account, I've published the 2 reports, they both show error, "There is no gateway to acces the data source", > Dataset setting to fix the error:
1. ImportQuery - Azure SQL DB -> Data Source Credentials -> input the correct credentials -> FIXED
2. DirectQuery - Azure SQL DB -> Data Source Credentials is DISABLED
I'm very confused on this, they are both consuming Azure SQL DB, but why is the DirectQuery is requiring to have onpremise gateway or the Datasource is disabled.
Kindly comment if I'm missing something here.
Thank you
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 |
---|---|
13 | |
6 | |
4 | |
3 | |
2 |
User | Count |
---|---|
13 | |
10 | |
5 | |
3 | |
3 |