Forum Discussion

vickyd's avatar
vickyd
Helper V
8 years ago

Special character not working in Query/URL parameter

We are passing a query parameter in the URL for a PBIRS report to pre-filter the data for an Account.    Account names with a & sign don't appear to be working though, even though it's encoded.   ...
Filters in url
rumittal's avatar
rumittal
Microsoft Employee
6 years ago

Anonymous, Thanks for the resopnse! 

Actually my query was what if there is special character like & in the filering value itself , for eg, 'X&YZ' 

 

I tried replacing it by %26 and it worked for me.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Yes rumittal  your response is a correct solution. Using the %26 for & worked for me but you do not need to use the unicode encoding for the spaces. The docs don't seem to say this and infact say the single quotation mark ' is the only thing you need to consider. 


Docs here seem to be wrong.