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!

Append query not working properly with PostgreSQL database

I am working in PowerBi desktop with a connection to a PostgreSQL database.

When tryping to add two tables together I get following error:

OLE DB or ODBC error: [DataSource.Error] PostgreSQL: 42804: UNION types character and bigint cannot be matched.

After some experimenting I learned that I works for following colums:

- colums in both tables

- colums with the type string

I am forced to remove all other colums after the append query tot dodge the error, but I need all columns.

 

Extra expample:

Table 1 with colums: name (string), age (int), hobby (string), shoe_size (int)

Table 2 with colums: name (string), age (int), job (string), nb_dogs (int)

Works: append table 1 and table 2 then remove colums shoe_size and nb_dogs. (Name and age can stay, because they are in both tables).

Doesn't work (but should): append table 1 and table 2.

 

My workaround: defining a view in the database.

 

 

Status: New
Comments
v-chuncz-msft
Community Support

@normalizedX 

 

You may try to add Table.Buffer and create a support ticket for assistance if necessary.