Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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_fi... 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
Hello try to modify your URL to this format:
[tile url]?filter=[table name]/[column name]%20eq%20%27"&[variable]&"%27 "
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,
I already tried static value and it's not working.
My Power BI have date of 18/01/2021 and when i'm filtering to 21/01/2021, which mean there is no data, the tile load and nothing change
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
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.
But i round microsoft links to explain how to filter in dashboard tiles...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
1 | |
1 | |
1 |