About URL filter , How to do when value contains "#"?

[danielllin]

Hi,

Does anyone knows how to revise my url when the value contains '#' ?

according to this article, (https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters)

URL filters already support all special characters in field values

but if my value contains '#', like #user001

when i paste the whole url, it will jump to PowerBI home page.

Thanks in advance,

Daniell

[danielllin]

Thanks! It works.

I tried to just change number sign(#) to %23, then it can work.

So actually, i don't need to change slashes or space. 

Really thanks!

[danielllin]

for example,  https://app.powerbi.com/reportEmbed?........&filter=table/column eq '#user001'

how to revise it?

Thanks

[v-easonf-msft · Accepted solution]

Hi, @danielllin 

?filter=table/column eq '#user001'

You can try replacing slashes(/) with %2f, spaces with %20,number sign(#) with and apostrophes(') with %27 in filter syntax based on  ASCII Punctuation & Symbols.

?filter=Table%2FColumn%20eq%20%27%23user001%27

Hope this will help you.

Best Regards,
Community Support Team _ Eason