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

[lbendlin]

Do you have that ProductFilter column prefiltered?

[abhiram342]

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