Power Query Refresh Not Updating Table Data in Excel

Question

Here's a detailed description of the problem:

• I upload data from various sources using Power Query.
• When I refresh the data, everything refreshes at the Power Query level (I see the new information in Power Query Editor).
• There are no error messages displayed during the refresh process.
• However, the new information isn't reflected in the final table in the Excel worksheet (new data is not loading to the table).
• I need to manually manipulate table properties and refresh again for the new data to appear. To get the new data to appear, I typically need to manually modify the external data properties in the table.

Answer 1

Hi,

Is your data source a local file or cloud data?

Make sure your data source has no authentication barriers.

Then I suggest you update Excel to the latest version:

1. Go to File > Account.
2. Under Product Information, click Update Options > Update Now to ensure you're on the latest version.

If none of the above methods work, you might try deleting the current table connection and recreating it from scratch:

Delete the table from the worksheet.

Go back to Power Query Editor, load the data again into a new table, and see if the issue persists.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---