cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
imocean
Advocate I
Advocate I

Power BI Tile in PowerApps not picking up filter

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. 

32 REPLIES 32

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
Advocate I
Advocate I

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
Advocate I
Advocate I

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! 

 

View solution in original post

MODEV
Frequent Visitor

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
Frequent Visitor

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 😉

(removed message after duplicate post)

HendrikDC
Frequent Visitor

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
Frequent Visitor

(removed message after duplicate post)

HendrikDC
Frequent Visitor

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
Frequent Visitor

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

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (47,324)