Forum Discussion
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.
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
I came across this error today.
My dataset would refresh without issue from within Power Bi Desktop, but failed in the service with "The type of column "xxx" conflicts with the type of other columns specified in the UNPIVOT list."
After finding this thread I checked my datatypes at source - SQL Server. All columns being unpivotted were of type BIGINT. When I changed this to INT (as my data allowed), the dataset refreshed without issue?!
Hope this may help someone in the future.