Unpivot Error: Data Source Error

Hi Anonymous,

Based on my research, it seems to be an SQL query issue with the Unpivot operator. Followings are two similar thread for your reference.

https://stackoverflow.com/questions/11158017/column-conflicts-with-the-type-of-other-columns-in-the-unpivot-list

https://dba.stackexchange.com/questions/54353/why-does-sql-server-require-the-datatype-length-to-be-the-same-when-using-unpivo

In this scenario, I would suggest you try manually writing the Unpivot SQL query, and use it to import data from Azure SQL Database using Native Database Query with Power BI. :smileyhappy:

Regards