Power BI EmbedURL-multiple filters

[aadrika]

0down votefavorite

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?

[jocaplan-MSFT]

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/

[kobaldm]

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]

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

[jocaplan-MSFT]

Which beta?

[akagiz]

This one 

https://github.com/Microsoft/PowerBI-JavaScript/tree/dev

[akagiz]

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

[kobaldm]

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]

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.