With Power Query, you can refresh a query to import the latest data into a table without having to recreate the query. If a refresh fails, Power Query preserves the previous query results. This allows you to work with slightly older data in the worksheet or Data Model, and refresh the query results after you fix the cause of errors. You refresh a query in the Query Editor.
Learn more about the Query Editor
You can access the Query Editor from the Navigator pane when connecting to a data source, or at any time from the Workbook Queries pane or the contextual Query ribbon tab for an existing query. To learn how to load the Query Editor, see Power Query Quick Start.
To refresh a query
- In the Query Editor ribbon, click Refresh.