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.
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!
HI @imocean ,
Do you want to display the Power BI tile within your app based on the filtered parameters?
I have made a test on my side, and don't have the issue that you mentioned. The screenshot as below:
Based on the formula that you provided, I think there is something wrong with it. Please consider modify your formula within the TileUrl property of the Power BI tile control to following:
"https://app.powerbi.com/embed?dashboardId=afdeccd3-28a5-41ce-ae04-0950f57f0d68&tileId=da52e0ea-d610-...&$filter=Scorecard/ScoreType eq '" & filteredAmountNumber.Text & "'"
Note: You have missed a ' (single quote) within above formula. You should use a ' (single quote) symbol to wrap the filteredAmountNumber.Text value.
Please take a try with above solution, check if the issue is solved.
Hi @imocean ,
Currently, I could not reproduce your issue on my side. The screenshot as below:
Please check if you have typed proper Table name and column name within your Tile Url. Please check the following article for more details:
Also please consider take a try to set the TileUrl property of the Power BI tile control to following:
"https://app.powerbi.com/embed?dashboardId=afdeccd3-28a5-41ce-ae04-0950f57f0d68&tileId=da52e0ea-d610-...&$filter=Scorecard/ScoreType eq 'Training'"
then check if the Line chart displayed within the Power BI tile control properly.
If the issue still exists, please re-create a new Power BI tile control within your app, try above solution I provided, check if the issue is solved.
Thanks a lot @v-xida-msft , I have already tried with the static value in the TileURL however still the same. I will go creating a new Power BI report from scratch to see if it would make any difference. Will let you know how I get on.
Hi everyone, this string was immensly helpful. I was also able to make some ground up by watching this video; https://www.youtube.com/watch?v=CWmU3gJ9tRY.
I was still missing one vital piece; plain text.
I did a bit of a workaround; I connected my combo box that was my filter for 'Clinic' to a Text Input field that I made invisible. It may be an extra layer, but it is working!
I was then able to get this hidden Text entry box (Clinicbox) to successfully filter by using, &$filerTableName/TableField eq '""& PlainText(TetxInputField) &"'" at the end of the Power BI TitleUrl . I hope this helps!
Thanks very much @tarinalees for the tip. I tried with it however still no luck. Can I ask you what data source you use for the Power BI Tile? I'm using Dynamics 365 and not sure if there is anything particular to it.
Check out our new profile badges recognizing authored solutions!
We are excited to announce the Power Apps Super Users!
Did you miss the call? Check out the Power Apps Community Call here.
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!