Skip to main content

Notifications

Announcements

No record found.

Customer experience | Sales, Customer Insights,...
Unanswered

How to use multiple filters into embedded power bI

Posted on by 160

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

pastedimage1667829211077v2.png

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

  • Sushma Patole Profile Picture
    Sushma Patole 160 on at
    RE: How to use multiple filters into embedded power bI

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans