Forum Discussion
lennyt99
Helper I
3 years agoNeed help on writing script to refresh power bi everytime excel file is updated once a day
What should I put in script? I don't know what to write
Thanks~
lennyt99 Hi, here is the detailed tutorial that can help you in achieving your desired outcome.
https://powerbi.microsoft.com/en-us/blog/refresh-your-power-bi-dataset-using-microsoft-flow/
3 Replies
- ppm1
Solution Sage
Is your Excel file stored on SharePoint or OneDrive? If so, why not just trigger a Power Automate flow whenever it is modified (and have your flow trigger the Power BI dataset refresh)?
Pat
- lennyt99
Helper I
Excel is in share point and how do I do that?
- AbbasG
Memorable Member
lennyt99 Hi, here is the detailed tutorial that can help you in achieving your desired outcome.
https://powerbi.microsoft.com/en-us/blog/refresh-your-power-bi-dataset-using-microsoft-flow/