Dynamic MQuery parameters URL Filtering

[abhiram342]

Hi all - We have created report based on dynamic m paramters using direct query. We want to pass query string parameter from report url and assign the value to dynamic m parameter. We have Web application and PowerBI report is referred in application by passing string parameter from report url i.e

example:

https://msit.powerbi.com/groups/xxxxxxxx-xxxxxxxxxxxxx-xxxxx/reports/xxxxxxxx-xxxxxxxxxxxxx-xxxxx/Re... eq '123456'

Error:

Thanks,

Abhiram

[Anonymous]

Hi @abhiram342 ,

Based on the error information, try to check the filters and make sure there are no problems.

Besides, the dynamic query parameter uses filter or slicer to filter data in the report, not the report url.

View the following document to learn about using query string parameters in the URL.

Filter a report using query string parameters in the URL - Power BI | Microsoft Learn

You can also view the following link to learn more about dynamic M query parameters.

Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.