Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have a Power BI Report embedded in Dynamics 365 on a Account Form. I already added a filter so that the report is filtered based on the selected Account.
<PowerBIFilter>{"Filter":"[{\"$schema\":\"basic\",\"target\":{\"table\":\"accounts\",\"column\":\"accountid\"},\"operator\":\"In\",\"values\":[$a],\"filterType\":1}]","Alias":{"$a":"accountid"}}</PowerBIFilter>
This filter works fine.
The Report now needs to be filtered both on Account AND on the user who is currently logged in to Dynamics 365.
I tried the add a second filter, but it doesn't work unfortunately.
<PowerBIFilter>{"Filter":"[{\"$schema\":\"basic\",\"target\":{\"table\":\"accounts\",\"column\":\"accountid\"},\"operator\":\"In\",\"values\":[$a],\"filterType\":1},{\"$schema\":\"basic\",\"target\":{\"table\":\"contacts\",\"column\":\"contactid\"},\"operator\":\"In\",\"values\":[$b],\"filterType\":1}]","Alias":{"$a":"accountid","$b":"contactid"}}
</PowerBIFilter>
So the question is, can I add multiple filters (from 2 different entities) to filter the report as desired? (based on the selected account AND on the user who is currently logged into Dynamics 365)
Looking forward to your response
Thanks!
Hi, @Anonymous
Hope these related documnents could be useful.
embed-powerbi-report-in-system-form
control-report-filters#advanced-filter
Pass-multiple-Power-BI-filters-from-embedded-Power-BI-report-in
Passing-Multiple-Parameter-filters-in-Power-BI-Embedded
Best Regards,
Community Support Team _ Eason
User | Count |
---|---|
64 | |
27 | |
25 | |
17 | |
11 |