Power BI Desktop Refresh All - Not Updating data in Power Query

[Chipsnump]

I have noticed that over the past few weeks, whenever I select 'Refresh All' in Power BI Desktop, only some tables actually update while others remain unchanged in Power Query. The refresh status in Power BI shows a successful update, but when I go to Power Query, a banner appears indicating that certain tables have not been updated for X days.

This happened to all dashboards.

[Anonymous · Accepted solution]

Hi @Chipsnump ,

Thanks for the reply from danextian / Akash_Varuna .

When you click “Refresh” in Power BI Desktop, the data in the data model is refreshed, while the preview data in the Power Query editor remains as previously cached.

The preview data is not updated automatically, you need to manually click “Refresh Preview” in the Power Query Editor to update the preview for a specific query.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[Chipsnump]

Hi @Anonymous 
Is it possible to happen to all daily power bi files? and how could we know what factors would create the cache version in power query?

[danextian]

Hi @Chipsnump 

That's just how the query editor behaves - what you're seeing is the cached version. Have you checked in table/data view if the udpated data is actually loaded?

[Chipsnump]

Yes, I did. The updating status showed successfully update, but when I go to power query, the table is sometimes outdated. So, I have to update it manually both in power query and power bi.

[Akash_Varuna]

Hi @Chipsnump Could you try upgrading and clearing cache here are some things could you check these please 

• Check Query Dependencies: Ensure all tables in Power Query have valid connections and no errors.
• Enable Table Load: Verify tables are not set to "Enable Load = Off" in Power Query.
• Clear Cache: Go to File > Options > Data Load > Clear Cache and refresh again.
• Update Credentials: Validate all data source credentials in Data Source Settings.
• Test Individual Tables: Right-click on tables in the Fields pane and refresh individually.
• Simplify Queries: Review and optimize complex Power Query transformations.
  If this post helped please do give akudos and accept this as a solution
  Thanks In Advance

[Chipsnump]

Hi @Akash_Varuna 
Thank you for your sharing, I did all the process as usual. Just wondering why do I have to delete cache almost every 3 days for every power bi files.