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

All responses (1)

Answers (0)

Suggested answer

Mustufa Furniturewala 50 on at

Like (0)

Report

RE: Power BI embedded in CRM Dynamics (Filter)

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