To refresh the data, you must click the "Refresh All" icon in the Connections sections of the Data tab. Of course, you can record a macro for that as well, so that you can simply use the hot key ...

A VBA macro can loop through each query and disable background refresh, allowing data updates to occur seamlessly without redundant processes. How to Automate Power Query with VBA Watch this video ...

Refreshing Power Query Automatically. To refresh Power Query automatically when the source data changes, you can use a macro. Here’s how to do it: ...