Forum Discussion

Chipsnump's avatar
Chipsnump
Advocate I
1 year ago
Solved

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

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.

Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    1 year ago

    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!

6 Replies

  • Akash_Varuna's avatar
    Akash_Varuna
    Super User
    1 year ago

    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's avatar
      Chipsnump
      Advocate I
      1 year ago

      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.

  • danextian's avatar
    danextian
    Super User
    1 year ago

    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's avatar
      Chipsnump
      Advocate I
      1 year ago

      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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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's avatar
      Chipsnump
      Advocate I
      1 year ago

      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?