Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Filter not working on Power BI tile in Power Apps

Hi all, 


Disclaimer: There was a previous discussion on an issue involving Power BI tiles and Dynamics 365 data, and I'm having a similar issue working with QuickBase. 


I've added a Power BI tile to my Power App. The Power BI report was created using data from Quickbase. The dashboard tile was then created from a report, like this.


My tileURL is as follows (with the IDs replaced with my own IDs):

"<dbID>&tileId=<tileID>&groupId=<groupID>&config=<config>&$filter=SchedulesDevTable/ActivityType eq '" & UserInput.Text &"'"

The graphic prints out fine and you can interact with it, but the filter doesn't work! 

I've tried this with/without plaint text, with a hard coded value, different columns, made sure there were no spaces in column headers that I've used, checked the column is type Text in Power BI.... All I get is the original grahic, no filtering.


I've also removed & re-added the tile to PowerApps, changed the graphic within Power BI and re-published to make sure the PowerApps interface was updating (it did), and refreshed everything. 



Community Support
Community Support

Hi @emannari ,

Please note that:

1)Table and Field names are case-sensitive, value isn't.

2)Special characters and spaces require some additional formatting. 

So, if your tablename and fieldname have the problem of  case-sensitive, please modify your formula.

If your tablename and fieldname have spaces/special characters inside, please modify your formula like this:

Identifier Unicode Coding for Power BI
Table Name Space is 0x20 Table_x0020_Name
Column@Number @ is 0x40 Column_x0040_Number
[Column] [ is 0x0058 ] is 0x0050 x0058_Column_x0050
Column+Plus + is 0x2B Column_x002B_Plus


What's more, there are a couple of things to be aware of when using the query string parameters.

  • When using the in operator, the values to the right of in must be a comma-separated list enclosed in parentheses.
  • In Power BI Report Server, you can pass report parameters by including them in a report URL. These URL parameters aren't prefixed because they're passed directly to the report processing engine.
  • Query string filtering doesn't work with Publish to web or Export to PDF.
  • Embed with report web part in SharePoint Online doesn't support URL filters.
  • The long data type is (2^53-1) due to Javascript limitations.
  • Report URL filters have a 10-expression limit (10 filters connected by AND).

Here's  a doc about it for your reference:



Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-yutliu-msft 


Thanks for the response & links. I'm doing everything you mentioned / some things don't apply:


1. My table & field names match the camelcase I used in the database

2. There are no spaces nor special characters

3. I'm not using the in operator

4. I'm using Power Apps, not publish to web, export as a pdf nor Sharepoint


I can successfully pass the same parameters within Power BI server as follows, and it works fine.<groupID>/reports/<reportID>/ReportSection<#>?filter=SchedulesDevTable/ActivityType eq 'Write'
Frequent Visitor

@emannari  Have you solved it - i have the same issue. I have searched the breadth and width - couldn't figure out why the filter wouldn't work in powerapp environment

Frequent Visitor

I have not! Haven't worked on it in awhile so if I find a solution I'll post here!

Frequent Visitor

You need set "AllowNewAPI" (you find it in PowerBI tile properties) to true otherwise the filtering will not work.

Check the image attached.

2021-08-04 12_40_59-.jpg

Responsive Resident
Responsive Resident

Hi @emannari 

Does the PowerBi report is pinned to a dashboard ? if so what type of pin is that ? is it pin live / pin visual. the dynamic filters will only work with pinned visuals and not with the pin live

Frequent Visitor

You need to Pin Visual (not Live Pin) to a dashboard, and you can use only 1 filter.

In the link you have a nice tutorial from Shane Young.

Frequent Visitor

I am also having this issue but my "AllowNewAPI" is already set to be true so I am stumped. Any ideas? 

Helpful resources

Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

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.

Users online (4,075)