Forum Discussion
Filter reports using Power BI URL - Not working
Our reports published in pbi App.
I am trying to filter a report using query string parameter in the URL. But it's not filtering the data.
Can you please guide what i'm missing
report published app URL (Orig) -
Tried URL (Not working) -
https://app.powerbi.com/groups/me/apps/b40221bb-3693-414f-8956-2647cd5df187/reports/cac93eb4-079f-431b-b5f5-5e1fd65a0948/ReportSection962ac1772065cbcd77b3?filter=SALES_REP/AD Name eq 'Mike Harvey' &ctid=493165ce-0076-480f-9f43-e1ef480c02a2 |
Reference: - Filter a report using query string parameters in the URL - Power BIhttps://docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters
- I think you need to escape the space in the column name, so ?filter=SALES_REP/AD%20Name eq 'Mike Harvey'.
Have a look at the special characters section:
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters#special-characters-in-url-filters
2 Replies
- I think you need to escape the space in the column name, so ?filter=SALES_REP/AD%20Name eq 'Mike Harvey'.
Have a look at the special characters section:
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters#special-characters-in-url-filtersthank you so much. it's working fine for me eq Condition. But i'm trying to pass multiple text values (AD Name) with in condition. it's not working.
i'm not able to figure out the reason. Can you please guide me
eq condition Working - https://app.powerbi.com/groups/me/apps/07e9a578-c3f1-4d2a-b67c-dd18d855ad91/reports/9bb8d0a1-7370-4324-9b02-626e373765b8/ReportSectionaaa8cc6570bd3a7488d0?filter=SALES_REP/AD_x0020_Name eq 'Mike Harvey'&ctid=493165ce-0076-480f-9f43-e1ef480c02a2
in not working - https://app.powerbi.com/groups/me/apps/07e9a578-c3f1-4d2a-b67c-dd18d855ad91/reports/9bb8d0a1-7370-4324-9b02-626e373765b8/ReportSectionaaa8cc6570bd3a7488d0?filter=SALES_REP/AD_x0020_Name IN ('Mike Harvey','Aron Bair')&ctid=493165ce-0076-480f-9f43-e1ef480c02a2
tried like this also in (Mike Harvey,Aron Bair)
