Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Memory allocation failure while loading 70 millions rows in power BI

 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.

 

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Anonymous 

       

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

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

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        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.