Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Unpivot - [DataFormat.Error] We couldn't convert to Time

Hi All,   I am strugling with an error OLE DB or ODBC error: [DataFormat.Error] We couldn't convert to Time.   I already tried solutions from below, but it did not work   https://community.powe...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Thank you for the attempt.

     

    I managed to find the issue. 
    4 errors that happend in column that was supposed to be time value. Calculation in that column caused cells to be over 1, immediatelly preventing it to be converted to time. Once i fixed these errors, unpivot worked like a charm :)

     

    I realy appreciate your asistance.

    Regards

    Filarap

d_gosbell's avatar
d_gosbell
Icon for Super User rankSuper User
7 years ago

Oh I thought your raw data was different.

 

But i'm not able to replicate your error. I pasted your example data into a new Power BI report, selected all the columns that were not time buckets then chose the UnPivotOtherColumns transformation which produced the PowerQuery step below

 

Table.UnpivotOtherColumns(#"Changed Type1", {"Duration(min)", "Starting Time stamp", "Ending Time Stamp", "Starting Bucket", "Ending Bucket"}, "Attribute", "Value")

 

This unpivoted the example data without an error. Are you able to share some example data (does not have to be real data) which reproduces your issue.

 

ps. Sorry for the late reply it appears that the forum notifications have stopped working

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thank you for the attempt.

 

I managed to find the issue. 
4 errors that happend in column that was supposed to be time value. Calculation in that column caused cells to be over 1, immediatelly preventing it to be converted to time. Once i fixed these errors, unpivot worked like a charm :)

 

I realy appreciate your asistance.

Regards

Filarap