Forum Discussion
Beginner user, error with date format!
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
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.
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
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,
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