How to update Power Bi dataset with SharePoint button

[Anonymous]

Hi everyone,

I basically have an excel file saved in the document library on SharePoint and this excel file is the dataset for my PowerBi dashboard which is also hosted on the same SharePoint page.

I would like to create a Power Automate flow that would allow the user to select a button which would refresh the Power Bi dashboard based on any new changes they made to the excel sheet.

Thank you!!

[Anonymous · Accepted solution]

I was able to do this with the "embed web" tile which allowed the pop-up part for the flow to work after selecting button. This doesn't work with the document library tile.

[amitchandak]

@Anonymous , refer if these can help

https://www.youtube.com/watch?v=SNfWEwb2-LQ

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

[Anonymous]

Thank you for the reply but unfortunetely these solutions aren't exactly what I'm looking for. I want to be able to update the dataset straight from SharePoint

[Syndicate_Admin]

You can use a trigger in Power Automate that is triggered when you change the Excel data entry file.

This way, your dataset will always be up-to-date and won't need to be updated manually.