Forum Discussion

julienvdc's avatar
julienvdc
Helper III
4 years ago
Solved

Filtering reports by URL with special characters

Hey everyone,

 

I am trying to filter a report using some parameters in the URL. My table and column have some special characters and I am following the guide here for those: https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters#special-characters-in-url-filters

 

However, it doesn't seem to be accepting the unicodes I am placing, so I was wondering if someone could tell me what I am doing wrong??? I am going crazy haha.

 

Here is what I've got without unicodes

?filter=[NEW] Topics/Level 2 ID eq 1219
--> table name is: [NEW] Topics & column name is: Level 2 ID & I want to filter by: 1219

 

Following the guide from Microsoft I've translated this into the following, but it doesn't work.... 😞

?filter=x005B_NEW_x005D_x00x20_Topics/Level_x00x20_2_x00x20_ID eq 1219

 

Do I have too many special characters?

  • Pfffff okay, my bad, seems like I wasn't well awake yet when I was trying this...

    I added an x too much when define a space... a space should be as this: _x0020_ and note like this: _x00x20_

1 Reply

  • Pfffff okay, my bad, seems like I wasn't well awake yet when I was trying this...

    I added an x too much when define a space... a space should be as this: _x0020_ and note like this: _x00x20_