Power BI embeded <PowerBIFilter> reference

[Snaefellsnes]

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

[Snaefellsnes · Accepted 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.

[Anonymous]

Hi @Snaefellsnes ,

Check the reference below:

https://crmkeeper.com/2019/03/24/power-bi-embed-to-dynamics-365-form-with-filtering/

 
Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Snaefellsnes]

Hi @Anonymous ,

Thanks for the link but it does not cover advance filtering when embedding powerBI reports.

Regards

[Snaefellsnes]

I solved my situation by using a view on SQL Server to perform what the left join as doing in Power BI with contains