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
Anonymous's avatar
Anonymous
Not applicable
6 years ago

http://localhost/ReportsPBI/powerbi/General/ReportByProducts?filter=Product_x0020_Category/Product_x0020_Name eq 'XYZ'

without url:   http://localhost/ReportsPBI/powerbi/General/ReportByProducts?filter=Product_x0020_Category/Product_x0020_Name eq 'XYZ' 

 

where:

'ReportByProducts' - name of report

'Product Category' - name of model. The space character replaced to "_x0020_"

'Product Name' - name of field. The space character replaced to "_x0020_"

eq  -  means equal

'XYZ' -  value for filtering

 

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.