cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
imocean
Level: Powered On

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. 

1 ACCEPTED SOLUTION

Accepted Solutions
imocean
Level: Powered On

Re: Power BI Tile in PowerApps not picking up filter

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

22 REPLIES 22
sayatan
Level: Powered On

Re: Power BI Tile in PowerApps not picking up filter

Is AccountID of type String ? I think this filter works only on string values.

imocean
Level: Powered On

Re: Power BI Tile in PowerApps not picking up filter

Thank you so much Sayatan. AccountID is a GUID. I just changed the filter parameter to filter on ScoreType which is a string but still the same... 

 

 

imocean
Level: Powered On

Re: Power BI Tile in PowerApps not picking up filter

The filter works perfectly in Power BI web app (as attached). 

Community Support Team
Community Support Team

Re: Power BI Tile in PowerApps not picking up filter

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:4.JPG

 

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.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
imocean
Level: Powered On

Re: Power BI Tile in PowerApps not picking up filter

Thanks @v-xida-msft for the testing and tip however still not working for me... can you check if I missed anything? 

 

image.png

Community Support Team
Community Support Team

Re: Power BI Tile in PowerApps not picking up filter

Hi @imocean ,

Currently, I could not reproduce your issue on my side. The screenshot as below:2.JPG

Please check if you have typed proper Table name and column name within your Tile Url. Please check the following article for more details:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/controls/control-power-bi-tile#pass-a-p...

 

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.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
imocean
Level: Powered On

Re: Power BI Tile in PowerApps not picking up filter

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. 

 

 

tarinalees
Level: Powered On

Re: Power BI Tile in PowerApps not picking up filter

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!

PowerBI Filter Works!.png

 

 

imocean
Level: Powered On

Re: Power BI Tile in PowerApps not picking up filter

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. 

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 441 members 6,596 guests
Please welcome our newest community members: