Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I am trying to call a powerBI from Dynamics CRM using the contains operator.
I use the following syntax to call a report using the is operator:
<PowerBIFilter>
{
"Filter": "[{\"$schema\":\"basic\",
\"target\":{\"table\":\"BrandChildParent\",
\"column\":\"kdc_accountNo\"},
\"operator\":\"Is\",
\"values\":[$a],
\"filterType\":1}]",
"Alias": {"$a": "kdc_accountno"}
}
</PowerBIFilter>
I have tried numerous syntax variations around this tag syntax with no luck:
<PowerBIFilter>
{
"Filter": "[{\"$schema\":\"advanced\",
\"target\":{\"table\":\"vw_BrandChildParent\",
\"column\":\"kdc_AccountNoKey\"},
\"operator\":\"Contains\",
\"values\":[$a],
\"filterType\":0}]",
"Alias": {"$a": "kdc_accountno"}
}
</PowerBIFilter>
Is there a reference somewhere on how to use the <PowerBIFilter> tag? I have found a few sites but nothing covers the xml usage in detail.
It may be a data type conversion problem (or peculiar syntax to use) as a poster in this thread suggest:
https://community.powerbi.com/t5/Desktop/Power-BI-embeded-CRM-Dynamics-365/m-p/988544
But it was unsolved on how to proceed.
Thanks
Solved! Go to Solution.
I solve my situation by re-organizing the query at the SQL Server level, by using a view that reproduces the left join I was using in PowerBi with contains.
I solve my situation by re-organizing the query at the SQL Server level, by using a view that reproduces the left join I was using in PowerBi with contains.
Hi @Snaefellsnes ,
Check the reference below:
https://crmkeeper.com/2019/03/24/power-bi-embed-to-dynamics-365-form-with-filtering/
Hi @Anonymous ,
Thanks for the link but it does not cover advance filtering when embedding powerBI reports.
Regards
I solved my situation by using a view on SQL Server to perform what the left join as doing in Power BI with contains
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |