Forum Discussion

banquovsky's avatar
banquovsky
Frequent Visitor
3 years ago
Solved

Power BI refresh stuck after Sort query

Hi Community, I am experiencing an issue with model refresh. I have a connection to a DataFlow, and everything works fine with the DataFlow and queries until I apply a Sort query.   Once I apply s...
Need Help
  • BA_Pete's avatar
    BA_Pete
    3 years ago

    Hi banquovsky ,

     

    Sorting rows is a 'whole table' operation i.e. it requires PQ to load the entire query into memory to perform.

    My guess is that you are hitting a resource limit when trying to apply the query to the model. This is usually due to a shortage of RAM and/or due to using the 32-bit version of PBI Desktop

     

    Options:

    -- Delete the Sort step from your query

    -- Ensure you use the 64-bit version of PBI Desktop

    -- Beef up your machine (and gateway) RAM. I find 48GB+ runs almost anything.

     

    Pete

banquovsky's avatar
banquovsky
Frequent Visitor
3 years ago

Hi BA_Pete,

Thank you for your advice. I upgraded the RAM on my machine from 16GB to 32GB, and the model refreshed in 40 minutes. It is working fine now. Thanks again!

BA_Pete's avatar
BA_Pete
Super User
3 years ago

 

Cool, glad it's sorted.

Don't forget to give a thumbs-up to any answers that have helped you along the way 👍

 

Pete