Forum Discussion
Filter data of Power BI in Power Apps
Hello,
i'm trying to filter data using the tileurl of Power BI in Power Apps but it's not working.
My tileurl : "https://app.powerbi.com/embed?dashboardId=6cf57dcd[...]&$filter=performance_line_summary/po_start_filter eq '" & Text(DatePicker1.SelectedDate;"[$-fr-FR]dd/mm/yyyy") & "'"
I've tried those links :
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/controls/control-power-bi-tile
https://www.inkeysolutions.com/blogs/embedding-powerbi-tile-in-powerapps/
Thank you in advance for your help
6 Replies
- lbendlin
Super User
dashboard tiles are not really interactive - if you click on them you are taken to the underlying report. I don't think you can apply filters to tiles.
Hi Anonymous,
As these documents mentioned, control tiles feature only existed in the power content which embeds in power apps. (notice: 'power apps' is different from 'power bi' app, they are different products)
I think you can test with static value first instead of direct interaction with the page elements. The selector should loading data after app loading but you are trying to invoke them before initiation.
Regards,Xiaoxin Sheng
HI Anonymous,
What type of value that you stored in the filter did you use in the URL filter? If your field store the text value, you do not need to add commas to package them.
In addition, I'd like to suggest you test with the table, fields that name with simple string without any special characters or whitespace.You can also take a look at the limit list of URL filter features to confirm if your scenario was not able to use this.
Filter a report using query string parameters in the URL#considerations-and-troubleshooting
BTW, please also check the power app limit and statutes to confirm the URL filter feature works normally on power apps side.
Regards,
Xiaoxin Sheng
Hello try to modify your URL to this format:
[tile url]?filter=[table name]/[column name]%20eq%20%27"&[variable]&"%27 "
