The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I am developing one complex Power BI report.
There are some issues in that occationally it requires a lot of memory and is slow to develop and debug.
I checked if we should optimize the report or if I should get a new laptop with more memory and the answer was the latter.
So now I got a brand new laptop with 64 GB of memory, but the problem is that I still get the same error in Desktop:
I looked for all of the settings and set them larger, but that didn't help.
And I am using only 22% of the memory according to Task Manager.
Any other settings I could change to use all of the memory for the Desktop?
"And I am using only 22% of the memory according to Task Manager."
Sponsor decided that we will not optimize the data model.
Hi @TimoRiikonen ,
It may be caused by the data model being too bloated(large data model , complex queries...) and low local machine configuration.
Please kindly check how much RAM and CPU Power BI is taking. And refer the official document to optimize the data model.
Hope these help:
https://community.powerbi.com/t5/Power-Query/How-to-Optimize-Memory-Usage/td-p/57915
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
79 | |
78 | |
44 | |
38 |
User | Count |
---|---|
157 | |
113 | |
64 | |
60 | |
55 |