How to set up automatic data dump from Power BI visual to excel

[siddrow]

Hi

I don't want to create a Power Automate button within my dashboard, I just want to set up a flow where the data automatically dumps out into an excel file (which will be saved in a Sharepoint folder) daily at 7am. I don't want one separate file saved down each day, just the one file to be constantly updated daily. The data also needs to be in an excel format, not PDF. I've doing some googling and have tried to follow a few videos with no success.

Please help 😁

[AlexisOlson · Accepted solution]

This sounds more like a Power Automate question, IMO, so I'd recommend asking in that forum.

Here's a specific thread that seems relevant to your question:
https://powerusers.microsoft.com/t5/General-Power-Automate/refresh-excel-every-morning/td-p/1272791

[siddrow]

Thank you, will reach out in that forum.