Power BI Dataset

[Anonymous]

Hi, i have a dataset that is about 18mb in size, it refreshes fine, but when i download to desktop regardless of RAM size (we have tried a computer with 12, 24 and 62gb of ram) and on each machines the file crashes and when looking at task manager the it is using 95%+ of RAM and same as CPU. The file has been rebuilt twice yet the problem persists, anyone got any advice as to what the cause might be

[v-chenwuz-msft]

Hi @Anonymous ,

Please set this value (as screenshot highlighted ) less than 90% of the RAM on the machine.

For more detail, please refre this article.

Evaluation configuration settings for Desktop - Power BI | Microsoft Docs

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , 18 MB file should do use that much of RAM

OPen a empty file -> Go to-> file -> options and settings -> options -> data load

check memory management cache, keep it between 4-8 GB. Clear the current cache. save these settings and exit.  Now try to open the file