The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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.
@Anonymous, Try using the code of & %26
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 |
---|---|
65 | |
62 | |
59 | |
54 | |
28 |
User | Count |
---|---|
181 | |
82 | |
66 | |
47 | |
44 |