Forum Discussion

Budfudder's avatar
Budfudder
Icon for Helper IV rankHelper IV
9 years ago

Loading Large Tables

I'm connecting successfully to our postgresql database. I then select the tables I want and attempt to Load them. Power BI fails with the error message about running out of memory - one of the tables...
Need Help
alanhodgson's avatar
alanhodgson
Icon for Solution Supplier rankSolution Supplier
9 years ago

Hey Budfudder,

 

I think the best practice for loading large datasets is using the Direct Query method instead of Import.

Also, are you running on a 32-bit or 64-bit machine? And do you have atleast 8GB of RAM?

 

I would also recommend looking at your current Connection Timeout configuration.

 

Cheers,

 

Alan

  • Budfudder's avatar
    Budfudder
    Icon for Helper IV rankHelper IV
    9 years ago

    I'm running Windows 10 64-bit, with 8GB of RAM.

     

    I'm using the Direct Query method, not Import. My mistake - we are using Import, we have no choice - Direct Query for postgresql is not supported.

     

    I'm unable to find the Connection Timeout configuration - where is it?

      • Budfudder's avatar
        Budfudder
        Icon for Helper IV rankHelper IV
        9 years ago

        Unfortunately (from what I can see) postgresql isn't one of the databases supported by DirectQuery - so I can ONLY import. Does importing actually create a copy of the whole table locally?

         

        I've had similar problems connecting to our CRM database (not timeouts or failures, but just HUGE load times) - again, it's not supported by DirectQuery.