cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
aadrika
Microsoft
Microsoft

Power BI EmbedURL-multiple filters

I have been trying to filter my embedded PBI report using the filter query syntax:

&$filter={tableName/fieldName} eq '{fieldValue}'

and this works for me. However, when I apply more than one filter, the filters are disregarded.

Is there a way to add multiple filters in the Power BI embed URL?

 

Also,I have this web app in which I am trying to display a report from my Power BI service. For that, I am using the URL which I received from the reports API. Is it possible to add multiple filters to this URL?

8 REPLIES 8
jocaplan-MSFT
Microsoft
Microsoft

We are working on a new client side API which will allow for a lot more filtering. I mention it in this blog post: https://powerbi.microsoft.com/en-us/blog/what-s-new-and-what-s-next-for-power-bi-embedded-july-2016/

i guess you refer to the 2.0 beta. 

I would be glad to test it. but still no luck. Any small hint ?

 

see my post

http://community.powerbi.com/t5/Developer/PowerBI-Client-2-0-beta-testing/m-p/51504#U51504

akagiz
Frequent Visitor

is there a way to install the beta for asp.net mvc, nuget?

Which beta?

akagiz
Frequent Visitor

As of today PowerBI Embedded supports only one expression in a filter, so something like 'ID eq 5 and Number gt 6' is NOT supported.

 

See my stackoverflow question and answer by a PowerBI engineer:

http://stackoverflow.com/questions/38366420/power-bi-embedded-odata-filter

i still did not got it work yet but checkout the demo folder

 

bower install powerbi-client#2.0.0-beta.8

 

michael

v-chuncz-msft
Community Support
Community Support

Hi aadrika,

 

Based on my research, the URL is based on the Open Data Protocol (OData). For details on the filter system query option ($filter), you may visit the OData URI Conventions specification and have a try.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors