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!
