Forum Discussion
Optimize memory
Hi! Please help me how to optimize, reduce the memory consumption in Power BI Desktop. I've got the message that I runned out of memory during refresh. I have a complex database with lot's of calc...
Anonymous,
Did you have large data in your data source? Please try to uncheck "Allow data preview to download in nthe backgroup" and "Enable parallel loading of tables" and check if this issue persists or not.
Regards,
Charlie Liao
Yes, but now I can't change the source from import to direct query and it would be really difficult to do an other report:/
And now I have only a few claculated columns, but it's still too many datas to refresh..
v-caliao-msft
Microsoft Employee
Microsoft EmployeeAnonymous,
Did you have large data in your data source? Please try to uncheck "Allow data preview to download in nthe backgroup" and "Enable parallel loading of tables" and check if this issue persists or not.
Regards,
Charlie Liao