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.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
At the monthly call, connect with other leaders and find out how community makes your experience even better.