Filter data of Power BI in Power Apps

[Anonymous]

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://sterlingsdotlife.wordpress.com/2019/03/04/controlling-the-power-bi-filter-context-from-withi...

https://www.inkeysolutions.com/blogs/embedding-powerbi-tile-in-powerapps/

Thank you in advance for your help

[ZL_S]

Hello try to modify your URL to this format:

[tile url]?filter=[table name]/[column name]%20eq%20%27"&[variable]&"%27 "

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[lbendlin]

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.

[Anonymous]

But i round microsoft links to explain how to filter in dashboard tiles...