Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I created a report using Dynamic M query parameters and direct query to a sql server source.
Filters work properly on Power BI Desktop: a table refreshes data with every click on filters.
Nonetheless, data is not refreshed when published to the Power BI Reporte Server -september 2022 ed.-. No error is displayed either.
Reference docs (https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters?source=re...) do not specify if this feature is expected to work on PBI Report Server as of the appointed edition.
Hence, I do not know how to regard this behaviour either as a bug or a missing feature.
Thanks for your confirmation.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @JSolano ,
There is indeed a known issue related to the M query parameter and it has been reported to the ICM, the id is 342965928. This issue is being fixed and please be patient.
Best regards,
Community Support Team Selina zhu