topic Re: Special character not working in Query/URL parameter in Report Server

Special character not working in Query/URL parameter

vickyd — Thu, 21 Jun 2018 22:05:36 GMT

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%2FAccountName%20eq%20%27AB%26C%27

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

Re: Special character not working in Query/URL parameter

youranupama — Tue, 07 Aug 2018 04:42:56 GMT

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

Re: Special character not working in Query/URL parameter

GGimenez — Mon, 13 Aug 2018 17:57:18 GMT

same here..! Any solution?

Re: Special character not working in Query/URL parameter

Anonymous — Tue, 21 Aug 2018 12:56:33 GMT

Any updates?

Re: Special character not working in Query/URL parameter

Anonymous — Thu, 25 Jul 2019 21:31:37 GMT

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.

Re: Special character not working in Query/URL parameter

rumittal — Wed, 06 Nov 2019 11:39:04 GMT

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_

Re: Special character not working in Query/URL parameter

Anonymous — Thu, 07 Nov 2019 13:30:40 GMT

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

Re: Special character not working in Query/URL parameter

rumittal — Thu, 14 Nov 2019 06:10:56 GMT

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.

Re: Special character not working in Query/URL parameter

Anonymous — Wed, 22 Jul 2020 16:35:07 GMT

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.