Power BI tile filter not working

[davinius]

Hi All,

i'm trying filter power bi tile on powerapps , but it doesn't work. when i triger fillter the Power BI Tile just refresh and stil did not filtere.

i already follow the turorial from any source but still not luck.

https://sterlingsdotlife.wordpress.com/2019/03/04/controlling-the-power-bi-filter-context-from-withi...

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/controls/control-power-bi-tile

This is my url with variable filter

Can any body help in this ?

Or is there any problem with this fiture right now ?

[davinius]

Hi @jovan , 

thank's for your responnse

1. the power bi tile is working and show my content, but can't filer with url modificaton

2. i'm using Sample Tile and copy the Embed URL but the power bi always loading.

 i tried with power bi sample base on this post

https://powerusers.microsoft.com/t5/News-Announcements-Formerly/Creating-dynamic-Power-BI-Tiles-in-P...

and the filter on url is working.

So i think the problem is on my PowerBi, i recreate the dashboard and still not filtered in powerapps.

is there any setup on power bi for this ?

[davinius · Accepted solution]

Hi all,

i have solution for my case and  thank's @jovan for save my day and now i can sleep well 😀

So my problem cause is Pin in PowerBI , i select "Pin A live Page" not a "Pin visual", because i think it's same pin to dashboard and the PowerBI Tile use the dasboard of Power BI.

The button Pin Visual does not appear when you are not in Edit report mode.

"Pin a Live page" can't filter on PowerBi Tile, but "Pin Visual" can, even though both of these methods can appear on PowerBI Tile.

Thank you.

[JillVillio]

Can you give me a little more info on your solution. I"m having the same problem. But when I try pinning a visual instead of a live page, the tile doesn't show up as an option in the dropdown on my powerapp tile control.

[IbrahimElsamman]

@JillVillio I think you will need to add a title and subtitle to your graph after you pin it (as vusual) to the dashboard (in powerbi.microsoft.com) and this will make it appear in PowerAPPs.

[db1989]

I was trying to figure it out for hours and then noticed that my table name had a space. After replacing every space in the URL with "_x0020_" I was finally able to filter my tile data. 

Same should apply for the column name.

This goes back to the following post:
https://powerusers.microsoft.com/t5/Building-Power-Apps/PowerBI-tile-in-PowerApps-column-names-with-...

[RafaelBertinott]

Hello All!

After changing this option to true,the filters starts working!!

I'm using the following sintax:
&filter=Table/Column%20eq%20%27parameter%27

Either my Table and column does not contain any spaces in their names.

[liyaquatl]

You're a god. Thank you so much. I went through the entire process of remaking the workspace, report, dashboard and it still didn't work. This property was the reason. Not sure when it got added but thank you! 

[Sssirisha1234]

Anyone please help regarding the issue I am facing ... integrated the report in canvas app and trying to filter but data is not filtered....I used the url"embedded url&$filter=tablename/clmnname eq 'value''pageName=report section" and I set allow new api true ....still it's not working can any one suggest me how to resolve this