(Solved) PowerBI Desktop taking too much CPU and Memory
PowerBI taking too much CPU and memory while opening any pbix file with multiple datasets. Several threads of Microsoft Mashup Evaluation Container running under Power BI which will take 100% CPU and 40-50% Memory. A larger machine with high specs may not resolve this issue as it is a memory leak in the Power BI Desktop which Microsoft has claimed to be working on. But the below solution will help in easing the solution and resources of the system.
Change the configuration of Power BI file from Options and disable the Background data downloading and Parallel loading as show below. Please note that these configurations are saved in each PBIX file, so you need to perform this on all the files