Computer RAM required for large datasets

[Anonymous]

Hi,

I will need to work with a large dataset of 200 millions rows in Power Bi Desktop. The PBIX will be around 2 GB and will be uploade in Premium. My computer has 8 GB of RAM, is it enough? What would be enough? How can I rationalize this to my boss? 

Many thanks,

Joel

[MartinBeaulne]

I recently  built a project with ~20millions lines in input mode, and my 32Gb RAM were overloaded.

I am looking forward to get a 128Gb system to be able to work without problems with my datasets, but my IT department seems to be misled by answers like v-yuta-msft's, who simply copy/paste the minimum requirements to run the application...

While it is no proof, I can safely say 64Gb is better than 32Gb to load a big file, having errors trying to load it on my 32Gb (i9) machine and no problem with my personal 64Gb (5950X) machine.

[v-yuta-msft]

Hi joelgagnon,

8GB RAM is enough to run run power bi desktop. Please see the minimum requirement for running power bi desktop below:

• Windows 7 / Windows Server 2008 R2, or later
• .NET 4.5
• Internet Explorer 9 or later
• Memory (RAM): At least 1 GB available, 1.5 GB or more recommended.
• Display: At least 1440x900 or 1600x900 (16:9) recommended. Lower resolutions such as 1024x768 or 1280x800 are not recommended, as certain controls (such as closing the startup screen) display beyond those resolutions.
• Windows Display settings: If your display settings are set to change the size of text, apps, and other items to more than 100%, you may not be able to see certain dialogs that must be closed or responded to in order to proceed using Power BI Desktop. If you encounter this issue, check your Display settings by going to Settings > System > Display in Windows, and use the slider to return display settings to 100%.
• CPU: 1 gigahertz (GHz) or faster x86- or x64-bit processor recommended.

Regards,

Jimmy Tao