topic Re: Dynamic MQuery parameters URL Filtering in DAX Commands and Tips

Dynamic MQuery parameters URL Filtering

abhiram342 — Fri, 22 Mar 2024 03:21:27 GMT

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/ReportSection?filter=ProductSearch/ProductIdFilter eq '123456'

Error:

Thanks,

Abhiram

Re: Dynamic MQuery parameters URL Filtering

lbendlin — Fri, 22 Mar 2024 19:24:40 GMT

Do you have that ProductFilter column prefiltered?

Re: Dynamic MQuery parameters URL Filtering

abhiram342 — Fri, 22 Mar 2024 22:35:24 GMT

Hi lbendlin - Yes, I have ProductFilter set with default Value. I think , I need to create new parameter to solve the issue i.e given preference to parameter from Query Parameter Over Parameter with in report i.e User can do filter product within product using FilterByList Slicer and User Can also come through the page from web application as well.

Thanks,

Abhiram