Special characters in the powerbi web url filters is giving issue

[Ashok_Gopeani]

Hello All,

we have created a dashboard and publish into workspace, then took web url and applied filter on one column (ex: Deal_Name). Its giving issue while loading the dash board if we pass the deal name with special characters in url. 

could you please let us know how deal with these special characters in powerbi service url, and is there any list of special characters to deal with 

Thank you in advance.

Regards,

Ashok G

[Anonymous]

Hi @Ashok_Gopeani ,

Hope all is going well.

I would be grateful for the documentation you provided.

Here are some commonly used replacement characters:

Assume you create the following URL query string:

https://app.powerbi.com/groups/me/reports/b7dea1d4-d9f0-47aa-a88d-xxxxxxxxxxxx/ReportSection2?filter=Executives/Executive eq 'Andrew%Ma'

It opens the Customer Profitability Example, filtered to show Andrew%Ma. However, if you look at the URL, it might now look like this:

https://app.powerbi.com/groups/me/reports/b7dea1d4-d9f0-47aa-a88d-xxxxxxxxxxxx/ReportSection2?filter=Executives%2FExecutive%20eq%20%27Andrew%25Ma%27

Spaces are replaced with 20%, %25 is used to replace the % between Andrew and Ma, %2F is used to replace the / between the table name Executives and the field name Executive, and %27 is used to replace the single quote '.

You can refer to my example to modify your code. If you have any questions, please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[marvinmeng]

Hi @Anonymous,

I use '%25' instead of '%' ,but it is not working now. Is it a bug?

Best Regards,

Marvin.

[Ashok_Gopeani]

Hi @Anonymous ,

Thank you for response and the url is working as you explained but the power bi dashboard is not loading as expected.

ex 1: i am hitting url without % character in filter

https://app.powerbi.com/reportEmbed?reportId=ff577b5d-16b3-43e5-8e8a-d379583fb1a4&autoAuth=true&ctid=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx&filter=dxxxxx_scenario_vw/xxx_NAME eq 'TEST XOI347'

and my dashboard has loaded property with filters on all pages

ex2: hitting url with % character in filter

https://app.powerbi.com/reportEmbed?reportId=ff577b5d-16b3-43e5-8e8a-d379583fb1a4&autoAuth=true&ctid=xxxxxxxxxxxxxxxxxx5&filter=xxxxxol_scenario_vw/xxxNAME eq 'TEST XO%I347'

if we keep % character, filters on all pages option itself is missing due to some error.

please verify and suggest..

thank you very much in advance.

[Ashok_Gopeani]

I have verified below url but for % (percentage) we are getting issue. as per below article the escape character for % is %25. but it is working for me... 

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

Could you please verify and let us know any solution we have