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

"https://app.powerbi.com/embed?dashboardId=<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. 

 

Help!

8 REPLIES 8
v-yutliu-msft
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:

https://docs.microsoft.com/en-us/power-bi/service-url-filters

 

 

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.

https://app.powerbi.com/groups/<groupID>/reports/<reportID>/ReportSection<#>?filter=SchedulesDevTable/ActivityType eq 'Write'
Neo2k
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

emannari
Frequent Visitor

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

Pocika
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

Krishna_R
Resolver IV
Resolver IV

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

Pocika
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.
https://www.youtube.com/watch?v=Boh_d8ybhVM

Rose12345
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

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

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