Hi Team,
I have embedded a power BI report into CRM using CRMtoolbox. I will load this report on account.
I wanted to provide multiple filters on power BI report like customer preferred Brand Name is ZARA and Account Name is 'ABC' .
How I can provide two conditions in CRM PowerBIFilter Parameters
{"Filter":"[{\"$schema\":\"basic\",\"target\":{\"table\":\"dim_contract\",\"column\":\"Tenant_Name\"},\"operator\":\"In\",\"values\":[$a],\"filterType\":1},
{\"$schema\":\"basic\",\"target\":{\"table\":\"dim_contract\",\"column\":\"Brand\"},\"operator\":\"In\",\"values\":[$b],\"filterType\":1}]"
,"Alias":{"$a":"name", "$b": "sic" }}