Beginner user, error with date format!

[RoboticPea]

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 parse the input provided as a DateTime value.". The thing is that I really don't have a date/time value in the values column for that pivot column, but I have some numeric values.

For the other segments this worked just fine, so I really don't understand what I could do...

Thanks in advance!

[Anonymous]

HI @RoboticPea,

I think it will be help if you share some sample data and snapshots.

In addition, if your date column stored date value with another date regain.(US date time and UK date time has different date format)

For this scenario, you can try to use 'using locale' option to choose correct date format or do some pre-format if your column not store regular date value.

Local date formats in Power BI

Regards,

Xiaoxin Sheng

[RoboticPea]

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]

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]

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]

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