Power BI embedded in CRM Dynamics (Filter)

(0) Share

Report

Posted on by Enrique

390

Hi!,

I have a field string in my CRM and use this field to filter my panel embedded in CRM. The problem is tha when the value of my filed is a number, does not work.

Example:

My field has a value = *00001 that works fine becouse y have a character .

My filed has a value = 10001, this does not work becouse the value is a number. Curiosly if it has 000001 works fine...

<control id="filteredreport" classid="{ - - - - }">
<parameters>
<PowerBIGroupId>xxxxxxxxx</PowerBIGroupId>
<PowerBIReportId>xxxxxxxxxxxxxxx</PowerBIReportId>
<TileUrl>app.powerbi.com/.../TileUrl>
<PowerBIFilter>{"Filter":"[{\"$schema\":\"basic\",\"target\":{\"table\":\"Customer\",\"column\":\"CodCustomer\"},\"operator\":\"In\",\"values\":[$a],\"filterType\":1}]","Alias":{"$a": "new_myfilterstring" }}</PowerBIFilter>
</parameters>
</control>

Thanks for the help.
Best regards

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Mustufa Furniturewala 50 on at

Like (0)

Report
Copy link

Link copied!

Hi Enrique,

Hope you are doing good.

We have observed this when an entity field value is a valid number, the value is sent to Power BI as a number but Power BI is expecting strings.

Solution : Update the "values" condition to surround the $a with escaped double quotes

<PowerBIFilter>{"Filter":"[{\"$schema\":\"basic\",\"target\":{\"table\":\"Customer\",\"column\":\"CodCustomer\"},\"operator\":\"In\",\"values\":[\"$a\"],\"filterType\":1}]","Alias":{"$a": "new_myfilterstring" }}</PowerBIFilter>

If this doesnt work, Then raise a support case and it will be taken care.

Hope this helps,

Mustufa F

1 people found this reply helpful.

Was this reply helpful? Yes No