Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
aadrika
Employee
Employee

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
Employee
Employee

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

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.