Memory allocation failure while loading 70 millions rows in power BI

[Anonymous]

 Hi folks,

I am getting below error while trying to load data using direct query.Initially it got  connected successfully  to HANA source which was failing in "Import " mode but when I started dragging columns in table visual , it gave "Memory allocation failure".

Any suggestion how can we load this much amount of data.

Thank you in advance.

[Anonymous]

Had this same issue a month ago. 2 things:

1 - Make sure you are running the same bit version as your operating system (32 of 64)

2 - Get a computer with higher end components (RAM and CPU)

[Anonymous]

Hi @Anonymous 

1]I use citrix,It has 32GB RAM allocated 

2]Power BI desktop and my OS version is same,64 bit

[Anonymous]

Try this:

File > Options & Settings > Options > Diagnostics > Crash Dumb Collection > Enable Now

See if you can replicate the issue then post the dump in this thread or a new post. Might tell us something.