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 ...
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!

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.