Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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...
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.
@MartinVaatt, Try using the code of & %26
https://www.w3schools.com/tags/ref_urlencode.ASP
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=__
User | Count |
---|---|
123 | |
76 | |
63 | |
50 | |
50 |
User | Count |
---|---|
175 | |
125 | |
60 | |
60 | |
58 |