Forum Discussion

Budfudder's avatar
Budfudder
Helper 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
Solution 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
Helper 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?