Need help on writing script to refresh power bi everytime excel file is updated once a day

[lennyt99]

What should I put in script? I don't know what to write 

Thanks~

[AbbasG · Accepted solution]

@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/

[ppm1]

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]

Excel is in share point and how do I do that?