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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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