Help needed with Filters using query strings in URL

[mpuricelli]

Hi,

I'm using URLs to filter a PBI script published online and export different versions to PDF.

The name of the Table is "PF_Data_2" and the filter is "ELT 1st Layer Name" with values of type "Name Surname"

This url worked when I tested it a couple days ago, but doesn't anymore in any browser. Does anyone have any ideas how to fix it?

https://app.powerbi.com/groups/21c58e8c-84a3-4756-9da8-d6fd9fc9fa47/reports/b6e21719-9644-4123-bdf1-...PF_Data_2%2FELT_00x20_1st_00x20_Layer_00x20_Name%20eq%20%27Name%20LastName%20%27

Thanks!

[v-xingshen-msft]

Hi @mpuricelli ,

It's been a while since I heard back from you and I wanted to follow up. Have you had a chance to try the solutions that have been offered? If the issue has been resolved, can you mark the post as resolved? If you're still experiencing challenges, please feel free to let us know and we'll be happy to continue to help!
Looking forward to your reply!

[lbendlin]

Please use the correct way to escape special characters. 

https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters#special-characters-...

[mpuricelli]

Hi Ibendlin,

Thanks, but what special character am I getting wrong?

_00x20_ for spaces in the table and columns

%20 for spaces in the value

All browser replace ' ' with %27

What is missing?

[lbendlin]

Escape the underscore too.