Forum Discussion

RoboticPea's avatar
RoboticPea
Regular Visitor
8 years ago

Beginner user, error with date format!

Hi everyone! I'm new to PowerBI and I'm trying to pivot a column. I splited my file in segments of 100 000 rows each and for two of those segments I get the error "DataFormat.Error: We couldn't pars...
RoboticPea's avatar
RoboticPea
Regular Visitor
7 years ago

I have something like:

Robotic; Pea; age; 100

Robotic; Pea; occupation; something

V-Shex; Msft; age; 150

V-Shex; Msft; nationality; PBI-country

V-Shex; Msft; time spent online; 5600

 

So my last column isn't really date/time, date or time per se because I have different kind of metrics there. I have a date/time column that is due identified.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi RoboticPea,

 

If this is a case, you can enter to query editor to modify column type which power bi recognize as date type but not stored really date values.

 

Regards,

Xiaoxin Sheng

  • RoboticPea's avatar
    RoboticPea
    Regular Visitor
    7 years ago

    Hi!

     

    I already tried that, forcing that column to be of type "Text", but PBI makes the same mistake (it automatically assumes that column is of type "Text" right from the beginning).

     

    The details about my error: 

    "DataFormat.Error: We couldn't parse the input provided as a DateTime value.
    Details:
    error:14077410: SSL routines: SSL23_GET_SERVER_HELLO: sslv3 alert handshake failure (external/openssl/ssl/s23_clnt.c:744 0x5d7ea6fd:0x00000000)""

     

    Thanks,

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi RoboticPea,


      Can you please share a pbix file and some sample data which can reproduce your issue? I will test on these files.

       

      Regards,

      Xiaoxin Sheng