Forum Discussion
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 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!
5 Replies
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
