Create a Power Automate button that refreshes report when changes are made in Excel sheet

[Anonymous]

How to add a Power Automate button into my Power Bi report that manually refreshes the dashboard with changes from the underlying data source which is an excel file that lives on SharePoint. Using the "refresh a dataset" when the button is selected doesn't seem to work.

For context the dashboard also lives on SharePoint.

Thank you!

[amitchandak]

@Anonymous , refer if these can help

https://www.mssqltips.com/sqlservertip/7414/refresh-power-bi-dataset-integrate-power-automate/

https://www.youtube.com/watch?v=-8NlEeIIRiQ