Forum Discussion
Memory error when refreshing
Thank you for your replies.
ankitpatira I doubled the cache size after you suggested it, this didn't seem to work at first but the refresh completed today and yesterday so maybe it had something to do with it after all. I'll accept this as the answer for now.
v-haibl-msft I use a lot of different sources, DirectQuery is not an option anymore.
GilbertQ I'll look into making the model more efficient. I exclude unneccessary data/columns as much as possible but I do have a lot of calculated columns/measures so maybe that's why completing the refresh was so difficult.
Sorry,
I "up" this post cause I got the same message.
I increase the Maximum Size (10 000Mo) and the message is the same.
Does anybody have an other issue?
PS : My version is a 32 bytes and I cannot (and not be able to) update on 64b
Hi Anonymous
It does appear that you have hit the 32bit memory limit. As suggested before possibly see if you can reduce the columns to enable for it to fit into the memory allocation for 32bit.
Ok, I did it...
39Mo, it's a small file, isn't it? There is no complex structure.
There is 10 000 rows and 50 000 rows on my 2 biggest tables (and few tables with 5 or 10 rows). I don't think it's big, don't you?
It also has to do with the data model (star is recommended) and cardinality, as mentioned before. Try to improve your data model (reduce as much text columns to keys as possible and have lookup tables for said keys). Try to perform as much of the calculated tables/columns in the query editor for improved compression. Turn off enabling load of tables that you don't use in the report. Try to make your tables skinny by removing as many columns as possible.
