Forum Discussion
Alirezam
Helper V
7 years agoOLE 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-msft
Community Support
- mussaenda
Community Champion
Do you have a "Changed Type" step after unpivoting? Remove it.