Showing results for 
Search instead for 
Did you mean: 
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


" &$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. 


Accepted Solutions
Advocate I
Advocate I

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 "$filter=accounts/accountnumber eq '" &filteredAccountNumber.Text &"'"

Thanks for everyone's help! 


View solution in original post

Advocate IV
Advocate IV

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

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... 



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

Community Support
Community Support

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:

"$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.

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



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:


Also please consider take a try to set the TileUrl property of the Power BI tile control to following:

"$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.

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;


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



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

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on June 15, 2022 at 8am PDT.

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.


New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Top Kudoed Authors
Users online (2,677)