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

Hi All, Could you please help if there is any solution to this ? It doesnt seem to be working with unicode and we need this urgently.

 

Anonymous , Did the example you showed worked ? It isnt working for me when I tried the same, it passed _x0026_ still as _x0026_

 

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.