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.
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.
Here's a doc about it for your reference:
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'
@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
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
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.
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.