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
Nothing seems to be working though. Is there a limitation on special characters?
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.
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_
without url: http://localhost/ReportsPBI/powerbi/General/ReportByProducts?filter=Product_x0020_Category/Product_x0020_Name eq 'XYZ'
'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.
Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.
Check out a full recap of the month!
Join this community-driven Power Platform digital event for unbiased support and problem-solving.
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.
Visit our Community Blog for articles, guides, and information created by fellow community members.