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.
We're getting errors using parameters in the datasource together with Direct Query in the May 2020 update.
Even if we just connect to one SQL Server table with parameters for server and database, after we close and apply we get the error: 'Connecting to tables from more than one database is not supported with Direct Query'.
In the Power Query editor the table is shown correctly (also after refresh) and with hardcoded server and database everything works fine, as well as in import mode using parameters.
We've used parameters in the datasource substantially in production so we're hesitant to deploy the May 2020 update.
Anyone an idea?
Martin
Hello,
same problem here ... not sure why Microsoft deploys a solution that is not downward compatible (guess that's just their customer friendly approach).
Anyway: any news on this yet?
(Or will I have to redesign all Power BI reports / start looking into alternative products?)
@bradsy are you aware of any issues in this area of parameters and Direct Query?
I have not heard any problems similar to this. If you can detail the repro a little better, we can give it a try to see if we can replicate the issue.
Thank you for responding.
I'll illustrate with a few screenshots...all in DirectQuery mode:
First with hardcoded server and database
after close and apply the connection is evaluated correctly.
Then with parameters 'ServerName' and 'DatabaseName'
after close and apply the next message appears during connection evaluation...
Allow parameterization in datasource is on.
Up till now this worked fine and as I said used all over production.
gr.
Martin
Hi Mart_lef,
I was not able to reproduce. The parameters were applied and my dataset kept working with DQ. Any other users seeing this?
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 |
---|---|
12 | |
6 | |
4 | |
3 | |
2 |
User | Count |
---|---|
14 | |
11 | |
5 | |
5 | |
3 |