office365 - How to automatically refresh data from external source without opening excel?

Question

I have an excel (.xlsx) file, it has a lot of sheets with tables that are based on data from an external SQL database. The file is stored in the cloud on OneDrive (I can also store it in SharePoint if it's easier). Now I have to open the file and press the refresh button to update the data (or on opening).

How can I make the external data in the file refresh itself every 30 minutes without touching a file? The built-in automatic update functionality works only if the file is open.

Also if needed, I can use power automate.

Thank you

Answer 1

等待大神答复