OLE DB or ODBC error

[Alirezam]

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)

[mussaenda]

Do you have a "Changed Type" step after unpivoting? Remove it.

[v-chuncz-msft · Accepted solution]

@Alirezam 

You may check the related steps Table.TransformColumnTypes in The Advanced Editor.