Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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