Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Issue with Dynamic M Query Parameters Binding using Power BI Desktop RS version and DirectQuery Mode

Hi,   We are  using Power BI Desktop Report Server May'2022 version.  When we try to implement Dynamic M Qyery Parameters with DirectQuery mode, we are getting error like below. Parameter Binding...
DirectQuery
frank_kress's avatar
frank_kress
New Member
3 years ago

Hello microsoft
I am a bit disappointed by the different "Power Bi Desktop Versions"
What the heck is the distinction between "Power Bi Desktop" and "Power Bi Desktop RS" regarding the topic "Dynamic M Query Parameters Binding using Power BI Desktop"

 

I tried the following example from the video (see link) with different versions of "Power Bi Desktop":
Dynamic M query parameters in Power BI Desktop 

With version: 2.112.1161.0 64-bit (December 2022) it works with a small mark, see the screenshot.

Still, the ColorOpt table is rendered as a DirectQuery, but in the Query Editor, the hint is to say something else.

A little confusing! Or ?

 

With the version: 2.105.1143.0 64-bit (May 2022) the same example was recreated unfortunately without success.


 

We work with the Report Server and the dashboards should be uploaded to it.
When will the desktop versions finally be identical?
I look forward to a quick reply. With a solution, of course. 🙂

Brgds Frank Kress