How to use multiple filters into embedded power bI

(0) Share

Report

Posted on by Sushma Patole

250

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" }}

I have the same question (0)

All responses (1)

Answers (0)

Sushma Patole 250 on at

Like (1)

Report

Lookup text is not supported by microsoft. Datatype has to be matched in power BI and CRM to use the fields for filter.

Hence only we can add business rules/ flow/workflow which will copy lookup text field to a new text field and then use same plain text field for filteration.

Was this reply helpful? Yes No