Filter not working on Power BI tile in Power Apps

[emannari]

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!

[v-yutliu-msft]

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,

[emannari]

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]

@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]

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

[Pocika]

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

Check the image attached.

[Krishna_R]

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]

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]

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

[pemorej]

This fixed my issue.  Thank you!!