Error Message for Unpivot Column

[khinzawhtwe]

Dear Sir/Madam,

When I created pivot table with power query linking to MS SQL source, below error message is showing in other client PC although query is working well in my PC that original report was created.

"Datasource.error: Microsoft SQL the type of column "Column Name" conflicts with the type of other columns specified in the UNPIVOT list"

Please help to solve this issue

Thanks!

KZH

[lbendlin · Accepted solution]

that is correct - all unpivoted columns need to have the same type.  If that is not the case for your source data then add a step before the unpivot to make them all the same type.