topic Re: Power BI EmbedURL-multiple filters in Developer

Power BI EmbedURL-multiple filters

aadrika — Sun, 03 Jul 2016 08:25:43 GMT

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?

Re: Power BI EmbedURL-multiple filters

v-chuncz-msft — Sun, 10 Jul 2016 06:05:33 GMT

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.

Re: Power BI EmbedURL-multiple filters

akagiz — Mon, 18 Jul 2016 12:03:18 GMT

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

Re: Power BI EmbedURL-multiple filters

kobaldm — Wed, 20 Jul 2016 10:07:52 GMT

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

bower install powerbi-client#2.0.0-beta.8

michael

Re: Power BI EmbedURL-multiple filters

jocaplan-MSFT — Wed, 20 Jul 2016 16:48:43 GMT

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/

Re: Power BI EmbedURL-multiple filters

kobaldm — Wed, 20 Jul 2016 18:25:58 GMT

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

Re: Power BI EmbedURL-multiple filters

akagiz — Wed, 20 Jul 2016 18:47:55 GMT

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

Re: Power BI EmbedURL-multiple filters

jocaplan-MSFT — Thu, 21 Jul 2016 15:57:22 GMT

Which beta?

Re: Power BI EmbedURL-multiple filters

akagiz — Thu, 21 Jul 2016 16:45:56 GMT

This one

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