Forum Discussion
Anonymous
3 years agoNot applicable
Filter embedded Power BI report using current user special characters
Filter an embedded report in the portal like the following link: https://powerusers.microsoft.com/t5/Power-Apps-Portals/Filter-embedded-Power-BI-report-using-current-user/td-p/703188
In the web template I have this code where I use the filter:
{%capture report_path%}https://app.powerbi.com/groups/00000000-0000-0000-0000-000000000000/reports/00000000-0000-0000-0000-000000000001/ReportSection01?filter=accounts/name eq '{{user.parentcustomerid.name}}' and accounts/address eq '{{user.address}}'{% endcapture %} {% powerbi authentication_type:"AAD" path:report_path%}
However the filter is crashing since the user data I'm passing contains special characters " ' " and " & ".
The value of the filters are:
{{user.parentcustomerid.name}} = "Domino's SA. DE C.V."
{{user.address}} = "Arkam & City #345678"
Is there any way to solve my problem?
Can someone help me here?
Thank you.
2 Replies
- amitchandak
Super User
- AnonymousNot applicable
Hello amitchandak, thank you very much for answering, the problem is that I don't know how to interpret it in this dynamic filter that I am establishing:
/ReportSection01?filter=accounts/address in ('F_%26_M','Arkam & City #345678')&ctid=__