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 ...

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: ...

Click "OK" to run the macro. Excel imports the spreadsheet data into the table. Advertisement. Article continues below this ad. ... right-click your table and select "Open" to refresh its view.