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.
