cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bchager6
Responsive Resident
Responsive Resident

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

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!

 

6 REPLIES 6
Eyelyn9
Community Support
Community Support

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
Responsive Resident
Responsive Resident

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

Eyelyn9
Community Support
Community Support

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.

URL FILTER.gif

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.

 

Eyelyn9
Community Support
Community Support

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.

Eyelyn9
Community Support
Community Support

Hi @bchager6 ,

 

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

 

?filter=_test_table/project eq 'P-1234'
 
3.15.5.url filter.gif
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
Responsive Resident
Responsive Resident

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.

 

bchager6_0-1616444293516.png

 

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.