Forum Discussion
Power BI Desktop Refresh All - Not Updating data in Power Query
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 TeamIf 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!
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
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.