Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
MiraNi
Advocate III
Advocate III

How to make filter work in embed report in CRM using text type column

We have embedded a report in CRM using secured embed code. We need to filter a customer in a report based on the selected customer is CRM. This worked fine, when we first had a customer column in Power BI as numeric type. But when column type was changed to text, filtering doesn't work anymore. How should we change the filter definition to make it work with text type column? Filter is added using json.

{"Filter": "[{\"$schema\":\"basic\",\"target\":{\"table\":\"VIEW_D_CUSTOMER\",\"column\":\"CUSTOMER_ID\"},\"operator\":\"In\",\"values\":[$a],\"filterType\":1}]","Alias": {"$a": "accountnumber"}}




0 REPLIES 0

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors