cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vickyd
Helper V
Helper V

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. 

 

 

Here's the actual URL

https://abc.com/Reports/powerbi/Account 360/A360TimeDashboard?rs:embed=true&filter=OrgDetails/AccountName eq 'AB&C'

 

Here's how it's getting passed post encoding

https://abc.com/Reports/powerbi/Account%20360/A360TimeDashboard?rs:embed=true&filter=OrgDetails%2FAc...AB%26C%27

 

Nothing seems to be working though. Is there a limitation on special characters? 

 

8 REPLIES 8
rumittal
Microsoft
Microsoft

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_

 

http://localhost/ReportsPBI/powerbi/General/ReportByProducts?filter=Product_x0020_Category/Product_x...

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

 

@volodymyrz, 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
Not applicable

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.

Anonymous
Not applicable

I used the same escape character format as this article explain. Replace the & with '_x0026_'

?filter table/column eq 'test '_x0026_' data'

The only problem I ran into was this seems to negate all other filters you pass in with the URL. This is the only one that comes through.

 

Hope this helps.

youranupama
Frequent Visitor

Do you have solution for this? Same issue with us.

same here..! Any solution?

Any updates?

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors