Forum Discussion
Aubinp
6 years agoNew Member
Power BI embeded CRM Dynamics 365
Hello everyone, In a dynamic CRM O365, I embeded a Power BI Report with a xml script following the instructions of the website : https://crmchartguy.com/2019/03/24/embed-filtered-power-bi-report...
clausm73
Advocate II
6 years agoI am experiencing the exact same "error" - so my filter works for a value 104000-0 but not 36944.
With this my filter looks like:
<PowerBIFilter>{"Filter": "[{\"$schema\":\"basic\",\"target\":{\"table\":\"Bridge Account\",\"column\":\"accountnumber\"},\"operator\":\"In\",\"values\":[$a],\"filterType\":1}]", "Alias": {"$a": "accountnumber"}}</PowerBIFilter>
On the other hand - if I adapt my filter to include " - [\"$a\"] - then its the other way arround - then 36944 works but not 104000-0.
<PowerBIFilter>{"Filter": "[{\"$schema\":\"basic\",\"target\":{\"table\":\"Bridge Account\",\"column\":\"accountnumber\"},\"operator\":\"In\",\"values\":[\"$a\"],\"filterType\":1}]", "Alias": {"$a": "accountnumber"}}</PowerBIFilter>
I assume there is some sort of data type guessing game happening in the embed components scripts and its guessing on the value not the underlying data type in the target or destination.