Power Automate scheduled refresh rather than button click

[Anonymous]

I have a dashboard with some calculated values on cards, I've figured out how to set up a power automate flow and have a button enabled that fills an excel spreadsheet with those values. Is there a way i can update the spreadsheet automatically instead of pressing the button, as the calculated values change everyday? I'm not sure how to set up the flow for it.

[vicky_]

Instead of using a power automate flow, wouldn't it be better to use the Service's built-in Scheduled-refresh? If you need the data to refresh after a change is made in the excel spreadsheet, consider running the refresh a dataset  action after the end of your existing flow.

[Anonymous]

Sorry, I should have been clearer in the original message. The report is set to refresh everyday and the values of the cards change. I want to input these new values into a spreadsheet with a table in the following columns: Date, Value 1, Value 2, Value 3 etc. Right now I use the Power Automate button that adds rows into an excel sheet - is there a way to do that automatically rather than having to click the trigger button each time.