Forum Discussion
Ideal PC Specs for Developing Reports for "Big Data"
The reports I'm working with import a large data source (1-2gb uncompressed with the typical fact table being 500M+ rows, 8 columns with multiple dimmension tables) and perform some computationally expensive measures. My PC specs up to this point haven't cut it. So my question is, what is the "Ideal Power BI Dev Machine"?
Here's the PC specs I've used up to this point:
I5-8400K + 16gb RAM + HDD
I5-8400K + 32gb RAM + SSD
Ryzen 9 5900X + 32gb RAM + NVME + 1660S
Thank you!
Hi lance_6
actually, the official document only mentioned Minimum requirements, but I think your PC specs are enough. Personally speaking, there's no absolute ideal machine. If the PC is still slow, maybe you can try to optimize the model
https://docs.microsoft.com/en-us/power-bi/fundamentals/desktop-get-the-desktop#minimum-requirements
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi lance_6
actually, the official document only mentioned Minimum requirements, but I think your PC specs are enough. Personally speaking, there's no absolute ideal machine. If the PC is still slow, maybe you can try to optimize the model
https://docs.microsoft.com/en-us/power-bi/fundamentals/desktop-get-the-desktop#minimum-requirements
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
When selecting a machine for data processing tasks, including creating reports with datasets of varying sizes, it's important to consider not only the clock speed (GHz) and the number of cores but also the type of processor cores. Here's an updated list with additional details, including core types alongside clock speed and RAM requirements:
Less than 500,000 rows:
- RAM Requirement: 64GB RAM
- Processor Core Requirement: Quad-core (e.g., Intel Core i5)
- Processor Clock Speed: 2.5GHz or higher
500,000 to 1 million rows:
- RAM Requirement: 128GB RAM
- Processor Core Requirement: Octa-core (e.g., Intel Core i7)
- Processor Clock Speed: 3.0GHz or higher
1 million to 5 million rows:
- RAM Requirement: 256GB RAM
- Processor Core Requirement: Dodeca-core (e.g., Intel Core i9)
- Processor Clock Speed: 3.5GHz or higher
5 million to 10 million rows:
- RAM Requirement: 512GB RAM
- Processor Core Requirement: Hexadeca-core (e.g., Intel Xeon)
- Processor Clock Speed: 4.0GHz or higher
Above 10 million rows:
- RAM Requirement: 1TB RAM
- Processor Core Requirement: Octadeca-core (e.g., AMD Ryzen Threadripper)
- Processor Clock Speed: 4.5GHz or higher