Dynamic M query parameters don't work when published

[frank11111]

We have a report which is using dynamic M query parameters and functions great on desktop.  When published we get an error:

"The cartridge generated a statement that is not valid because more than one text statement was generated, the statement was not the correct type, or more than one parameter list was generated. The generated statement that is not valid is: ."

This is similar to the question shown at the link below.  That question is marked as resolved, which it is not (it says it "will be" resolved early April but it isn't clearly).  Whether or not the features that came out in the March 2022 release of Power BI function the same when published is a matter of great consequence for us and greatly impacts how we solve certain problems moving forward.  Please mark things resolved when they are actually resolved for users!

https://community.powerbi.com/t5/Service/Help-with-Published-report-using-a-parameter-in-Dynamic-MQu...

[frank11111]

It is working for us now.  Thank you!!

[v-luwang-msft · Accepted solution]

Hi @frank11111 ,

I had a discussion with the colleague who answered the question about the issue. Microsoft related engineering previously replied that the fix was completed in early April, but there is a sequence of fixes for each data center. When my colleague tested the issue in his own environment last Friday, the fix was not yet complete, but today, when he opened his own environment, the fix was complete. Since your problem was created last week, you can test it again in your own environment to see if the problem is fixed.

Best Regards

Lucien