Forum Discussion
Power BI embeded <PowerBIFilter> reference
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
- Anonymous6 years ago
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.
4 Replies
- AnonymousNot applicable
Hi Anonymous ,
Check the reference below:
https://crmkeeper.com/2019/03/24/power-bi-embed-to-dynamics-365-form-with-filtering/
Best Regards,
KellyDid I answer your question? Mark my post as a solution!- AnonymousNot applicable
Hi Anonymous ,
Thanks for the link but it does not cover advance filtering when embedding powerBI reports.
Regards
- AnonymousNot applicable
I solved my situation by using a view on SQL Server to perform what the left join as doing in Power BI with contains
- AnonymousNot applicable
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.