cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Cleared Frequent Visitor
Frequent Visitor

Filter on tiles using the new Embedding api

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator Eric_Zhang
Moderator

Re: Filter on tiles using the new Embedding api

@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.

5 REPLIES 5
teroman Frequent Visitor
Frequent Visitor

Re: Filter on tiles using the new Embedding api

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!

Cleared Frequent Visitor
Frequent Visitor

Re: Filter on tiles using the new Embedding api

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

Moderator Eric_Zhang
Moderator

Re: Filter on tiles using the new Embedding api

@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.

teroman Frequent Visitor
Frequent Visitor

Re: Filter on tiles using the new Embedding api

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.

Highlighted
harigovind511 Frequent Visitor
Frequent Visitor

Re: Filter on tiles using the new Embedding api

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