Filtering a report using query string parameters for special characters in the URL

[bchager6]

Hi everyone,

I have been trying to generate a URL to filter a report I use by a specific project, with no luck. Hoping someone can help.

The table and field I want to reference is _test_table/project

I'm using the unicode character 005F, preceded by _x  and followed by _ to account for the underscore before and after "test." 

So at the end of the report URL I type ?filter=_x005F_test_x005F_table/project eq 'P-1234'

I've also tried ?filter=_x005F__test_x005F__table/project eq 'P-1234' to include the underscore along with the unicode character for it.

Neither options work. Kudos to anyone who can figure this one out!

[v-eqin-msft]

Hi @bchager6 ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it.

Hope to hear from you. Thanks in advanced.😀

Best Regards,
Eyelyn Qin

[bchager6]

Hi @v-eqin-msft . Unfortunately not. The only solution I have found is if I rename my table from _project_table to projecttable without the underscores. 

[v-eqin-msft]

Hi @bchager6 ,

Please upgrade your Power BI Desktop to the latest version and have a try again.

The suffix of-->  ?filter=_test_table/project eq 'P-1234' works fine on my side.

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-eqin-msft]

Hi @bchager6 ,

According to the error message, it seems that you have trouble logging in Power BI not the URL Filter.

Please close all brower windows and have a try again.

If it does not make sense , please use another browse or clear cookies & cache.

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-eqin-msft]

Hi @bchager6 ,

Based on my test, you could use underscore directly instead of converting in URL:

?filter=_test_table/project eq 'P-1234'

Please notice the end of the URL is ReportSection(Sometimes there will be a suffix of a page code)

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[bchager6]

Thank you. I appreciate your help here but it's not working for me for some reason. I've tried with a report and an App and receive the below message.