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.
Solved! Go to Solution.
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 &"'"
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!
User | Count |
---|---|
195 | |
126 | |
91 | |
48 | |
44 |
User | Count |
---|---|
280 | |
165 | |
138 | |
81 | |
76 |