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...
Anonymous's avatar
Anonymous
Not applicable
8 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