Forum Discussion
Power BI refresh stuck after Sort query
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
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
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!
Cool, glad it's sorted.
Don't forget to give a thumbs-up to any answers that have helped you along the way 👍
Pete