Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Partial Data Import

Hi,

 

I've connected to our Postgre database via the ODBC connection however it's only doing a partial import. Of the 55k rows in one table, it's only imported 21k rows. This is my second attempt, initially I tried importing the full data set (500k+ rows) and it only imported half, I've imposed a filter in the hope that it would make a difference. We're using ODBC because there were issues with installing the drivers for connecting via postgre.

 

I'm on the 60 day free trial at the moment, and couldn't open a support ticket. There appears to be no help number either. Can anyone advise? Thanks,

 

David

Status: Needs Info
Comments
v-jiascu-msft
Employee

Hi David,

 

I seems the issue is from the PostgreSQL ODBC drive. Please upgrade to the latest version, 10.01 for now. I tested it with a 524288 rows table successfully.

Partial_Data_Import

 

Vicky_Song
Impactful Individual
Status changed to: Needs Info