Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.