cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Regular Visitor

Re: Power BI Browser <PowerBIFilter>Reference</PowerBIFilter>

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.

View solution in original post

4 REPLIES 4
Highlighted
Solution Sage
Solution Sage

Re: Power BI embeded <PowerBIFilter> reference

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!

 

 

Highlighted
Regular Visitor

Re: Power BI embeded <PowerBIFilter> reference

Hi @v-kellya-msft ,

 

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

 

Regards

Highlighted
Regular Visitor

Re: Power BI Browser <PowerBIFilter>Reference</PowerBIFilter>

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.

View solution in original post

Highlighted
Regular Visitor

Re: Power BI embeded <PowerBIFilter> reference

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

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors