Forum Discussion
Data refresh with memory problem
Actually SQL should not really consume anything because it's running on server, not on your PC. Nevertheless I think Server Analysis Services runs everytime when load in Power Query is importing data.
If the PC has 12 GB total memory, do not enable full 12 GB for PBI. Windows will not have enough memory to run and leads to easy crash. Maybe try something like 8 GB for PBI , 4 Containers and 2GB per container.
Hi Migasuke
Thanks for your reply, your solution is interesting in fact.
I tried different combination of variables by changing values in max number of simultaneous evaluations, their size and cache size but didn't work out. Do you have any specific combination in mind that might work?
FYI: my PBI is 100 Mb, has 30 tables in the data model and the PC has 12 Gb of RAM (not 16)
Thanks
Hi again,
I opened Task Manager while the file is refreshing data and it seems that the problem is not from Power BI, but from SQL Server Analysis Services! Which went up to consume up to 8 gb of RAM before Power BI gives me the update error.
Actually SQL should not really consume anything because it's running on server, not on your PC. Nevertheless I think Server Analysis Services runs everytime when load in Power Query is importing data.
If the PC has 12 GB total memory, do not enable full 12 GB for PBI. Windows will not have enough memory to run and leads to easy crash. Maybe try something like 8 GB for PBI , 4 Containers and 2GB per container.