Within Power Automate, it has been possible to run scripts in Excel using the Run Script action. Did you know that there is a ...

To enable automatic updates, simply refresh the Power Query connection to your folder. Excel will scan the folder for any new files and seamlessly integrate them into your existing dataset.

The When a file is create or modified trigger has quite a few options available however there is no options to control how often you want Power Automate to check.