Forum Discussion
How to update Power Bi dataset with SharePoint button
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!!
- Anonymous3 years ago
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.
4 Replies
- amitchandakSuper User
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/
- AnonymousNot applicable
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_AdminAdministrator
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.
- AnonymousNot applicable
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.