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

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

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 (3,287)