Forum Discussion
Alirezam
7 years agoHelper V
OLE DB or ODBC error
Hi dudes,
I have a table reading from a .csv file. There is no wrong, missing or unusual characters in the records. Whenever I refresh in Power Bi, I get this message and it only occurs when I unpivot the two of the columns. Before unpivoting, it sounds like working well. Any assistance?
OLE DB or ODBC error: [DataFormat.Error] We couldn't convert to Number
when I follow, I see this:
DataFormat.Error: We couldn't convert to Number.
Details:
TIME (-3602)
2 Replies
- v-chuncz-msftCommunity Support
- mussaendaCommunity Champion
Do you have a "Changed Type" step after unpivoting? Remove it.