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

can you explain clearly what kind of issues you are facing ? so that you can get better help from people.
Subhashini17
Frequent Visitor

The TileURL should be in the form of :

Link of the Power BI dashboard followed by &$filter=tablename/columnname eq '" &the label to be compared"'"

in my case is "https://app.powerbi.com/embed?dashboardId=afdeccd3-28a5-41ce-ae04-0950f57f0d68&tileId=2aba81d3-3c69-...&$filter=Customer/itemnumber eq '" &itemnumber.Text &"'"

beray3088
New Member

Hi All- I even did it but still dose not work.

More detail that my report was build by imported Live data.

All fields are without empty space...please advise if still missing some.

Thanks!

beray3088_0-1604632821276.png

 

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.

Top Solution Authors
Top Kudoed Authors
Users online (71,520)