Power BI Tile in PowerApps not picking up filter

[imocean]

Hi Guys, keen to get suggestions here. I embedded a Power BI tile in my PowerApps app, however the filtering doesn't work at all. It just shows the whole dataset from the Tile. A brief of the details,

1) Power BI Tile pinned from a Power BI Report, very basic chart visual looking at a table called 'Scorecard' with a few fileds including AccountID which is the one I'd like to filter on from PowerApps (as shown in the attached screenshot PowerBITile.gif)

2) In PowerApps the Power BI Tile got embedded successfully. I use a variable to pass on the AccountID parameter and append to the TileURL as below (the bold part is the appended filtering parameter) (as shown in the attached screenshot PowerBITile in PowerApps.gif, I followed this article https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/controls/control-power-bi-tile)

"https://app.powerbi.com/embed?dashboardId=afdeccd3-28a5-41ce-ae04-0950f57f0d68&tileId=da52e0ea-d610-... &$filter=Scorecard/AccountID eq "&filteredAccountId.Text 

However the filter isn't picked up at all. I tried hardcoding with an AccountID, removing the spaces, adding single quotes around the parameter (filteredAccountId.Text) but no luck at all. It always shows the whole dataset from the Tile. What have I done wrong? Thanks a lot in advance. 

[tarinalees]

Hi @imocean, I am using a SharePoint List as the data source. Dynamics 365 is a bit tricky already from my very limited experience. I am only starting down the path of using my data in Dynamics with PowerBI and I haven't embedded a tile in PowerApps for that data source yet. I will post if I am able to get something to work! 🙂

[imocean]

Hi All, Sorry for not updating on this one for a while. I've engaged with MSFT support engineers on the case and they have confirmed a bug was introduced just recently which affects the filtering with Dynamics 365 data source. They will put in a fix in late July so will test it out then and report back if it's all good by that time.

Thanks everyone for the help, I really appreciate it.

[imocean · Accepted solution]

Hi all, 

Just to report back that the issue has been resolved so now it's all working as expected. The TileURL in my case is "https://app.powerbi.com/embed?dashboardId=afdeccd3-28a5-41ce-ae04-0950f57f0d68&tileId=2aba81d3-3c69-...&$filter=accounts/accountnumber eq '" &filteredAccountNumber.Text &"'"

Thanks for everyone's help! 

[MODEV]

Hello World, I try to put a filter for my power till in my powerapps and i have two problems: The first one is if i process like in the video https://www.youtube.com/watch?v=CWmU3gJ9tRY if i clic into the powerbi till in my powerapps, it open powerbi ;-( i would like to stay in powerapp and use the other fields of the till to filter the data The second one is that it doesn't work for me: My table in powerbi: TR_DW_GCO_DS10, My Field: article_laboratoire, My IinputTExtBox in powerapps(text format): Article_Laboratoire "https://app.powerbi.com/embed?dashboardId=94f6e3f0-be23-4f83-8248-b9c79e3f7cff&tileId=94433fa4-0a51-... eq '" &Article_Laboratoire.Text &"'" Can someone help me ? Thanks a lot

[MODEV]

hello, With this geat video i made progress ;-( https://www.youtube.com/watch?v=Boh_d8ybhVM thanks to shane young But it still doesn't work and i can't understant why ;-( THis my the url of my report power bi and thats 'ok: /reports/f0c0e921-300f-4236-81e2-86fbea30bb30/ReportSection?filter=TR_DW_GCO_DS10/Article_Laboratoire eq 'INELDEA' When i try to do the same on the titleurl properties in powerapps: 5ldCJ9&filter=TR_DW_GCO_DS10/Article_laboratoire eq 'INELDEA'" : nothing happen (no filter). thanks for you help 😉

[HendrikDC]

(removed message after duplicate post)

[HendrikDC]

I've got a similar issue. I followed all the instruction here but still no luck. I'm working with a simple test with 1 table called 'AgeTable' containing fields Name and Age.

I'm able to filter the report by a fixed value 'Person1' on PowerBI.com:

https://

app.powerbi.com/groups/2eaea814-7512-4c37-9c01-f5dbd992c775/reports/c9bbe1e0-e22b-4449-80b3-3ad08e57eeab/ReportSection?filter=AgeTable~2FName%20eq%20%27Person1%27

However, when I do the same on a Power BI Tile on a PowerApp, I'm unable to filter:

https://

pp.powerbi.com/embed?dashboardId=863df555-c952-40e8-bc55-45a8a86a5178&tileId=0e611af5-4f90-46e2-9964-b936442f1205&config=eyJjbHVzdGVyVXJsIjoiaHR0cHM6Ly9XQUJJLUFVU1RSQUxJQS1TT1VUSEVBU1QtcmVkaXJlY3QuYW5hbHlzaXMud2luZG93cy5uZXQifQ%3d%3d&$filter=AgeTable/Name eq 'Person1'

I already upgraded to a Power-BI pro trial license, but no luck.

Anyone any idea?

Thanks

[HendrikDC]

(removed message after duplicate post)

[HendrikDC]

I've got a similar issue. I followed all the instruction here but still no luck. I'm working with a simple test with 1 table called 'AgeTable' containing fields Name and Age.

I'm able to filter the report by a fixed value 'Person1' on PowerBI.com:

... c9bbe1e0-e22b-4449-80b3-3ad08e57eeab/ReportSection?filter=AgeTable~2FName%20eq%20%27Person1%27

However, when I do the same on a Power BI Tile on a PowerApp, I'm unable to filter:

... XMud2luZG93cy5uZXQifQ%3d%3d&$filter=AgeTable/Name eq 'Person1'

I already upgraded to a Power-BI pro trial license, but no luck.

Anyone any idea?

Thanks

[MODEV]

Hello,

I'm trying to find a solution: and i wonder if there's not difference between version of Powerapps

Which language pack do you use? (For me it is in french)

I had call Microsoft Support for this problem