Filter reports using Power BI URL - Not working

[rveerasamy]

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) - 

https://app.powerbi.com/groups/me/apps/b40221bb-3693-414f-8956-2647cd5df187/reports/cac93eb4-079f-43...

Tried URL (Not working) - 

https://app.powerbi.com/groups/me/apps/b40221bb-3693-414f-8956-2647cd5df187/reports/cac93eb4-079f-43...?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

[nickyvv · Accepted solution]

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-i...

[rveerasamy]

thank 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-43..._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-43...?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)