topic Re: Filter on tiles using the new Embedding api in Developer

Filter on tiles using the new Embedding api

Cleared — Tue, 20 Jun 2017 11:26:20 GMT

I am using the new emedding api and i want to embedd tiles on an external webpage. However i need to apply a filter to the tiles, for example TableA/ColumnB = "ABC" but i am unable to do this.

I am doing it by adding a filter-property to my config according to https://github.com/Microsoft/PowerBI-JavaScript/wiki/Embed-Configuration-Details:

filters: [
            {
                target: {
                    table: "TableA",
                    column: "ColumnB"
                },
                operator: "In",
                values: ["ABC"]
            }
        ]

but it doesnt work. If i do the same but embedd a full report, it works perfectly. Is it not possible to add filters to tiles?

Re: Filter on tiles using the new Embedding api

teroman — Tue, 20 Jun 2017 15:27:26 GMT

I had the same problem using the older api, I found you could add a single filter by adding

&$filter=table/column eq 'ABC'

to the iframe.src, but adding multiple filters using " and " would cause none of the filters to be applied.

Really hoping there is a solution for applying parameters to embeded tiles!

Re: Filter on tiles using the new Embedding api

Cleared — Wed, 21 Jun 2017 06:28:07 GMT

That does not seem to work for me. Are you sure that this works when imbedding a tile, and not only for full reports?

Re: Filter on tiles using the new Embedding api

Eric_Zhang — Wed, 21 Jun 2017 07:52:54 GMT

@Cleared

It seems by design. If you check Understanding the object hierarchy, you'll find NO filter for tiles and dashboards. There're only filters for Visuals(not implemented, tiles are not visuals), Pages and Reports. If you'd like a filtered tile, add visual level filter before pinning them to dashboard.

Re: Filter on tiles using the new Embedding api

teroman — Wed, 21 Jun 2017 09:13:39 GMT

I don't think adding the filters when putting the tile on the dashboard will allow them to be changed at runtime through the api. They'll just be static values as set up when the pinning was done, is that right?

What we want to do is have a selector in our app, and then apply those selections to the tile as the user clicks around.

Re: Filter on tiles using the new Embedding api

harigovind511 — Mon, 21 Jan 2019 12:20:41 GMT

Hey,

Did you figure out how to do this? I am also trying to do the same but when I apply filters on the Visual I get an error like "Setting Visual Level filters is not Supported".

Any help is appricieated.

Regards,

Hari

Re: Filter on tiles using the new Embedding api

dom99 — Mon, 09 Dec 2019 08:45:44 GMT

Hi,

Does anyone know if there are any further updates on this? We are looking to implement filtering on dashboard tiles via the API or otherwise interactivly.

Thanks