Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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 sorting in the Query Editor, I click "Close and Apply" as usual, and the refresh starts. However, after some time, it gets stuck with no further response, just displaying "refreshing". I left it overnight, but there were no results. It seems like it attempted to refresh all the data (approximately 4.7GB) but couldn't complete the process.
Is it possible to find out the reason behind this issue? Is there any way to access logs or other information?
Here is an example of the code:
"
#"Sorted Rows1" = Table.Sort(#"Filtered Rows1",{{"Task", Order.Ascending}, {"SLA respect", Order.Ascending}}),
#"Removed Duplicates1" = Table.Distinct(#"Sorted Rows1", {"Task"}),
"
Thanks in advance.
Solved! Go to Solution.
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
Proud to be a Datanaut!
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
Proud to be a Datanaut!
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
Proud to be a Datanaut!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
24 | |
13 | |
12 | |
11 | |
8 |
User | Count |
---|---|
43 | |
26 | |
16 | |
15 | |
12 |