Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DataFormat.Error: We couldn't parse the input provided as a DateTime value.undefined.

I have a csv file that has date data in dd/mm/yyyy hh:mm format. After importing the data into PowerBi, I click on the columns with the date data and change the type from Text to Date. PBI recognize...
CSV
Date
Type
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Team Tang,
    I found the solution to the issue. I needed to select "Using Locale" when selecting to change the "Type". See below.

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Team Tang,
I found the solution to the issue. I needed to select "Using Locale" when selecting to change the "Type". See below.

 

DaddyFresh87's avatar
DaddyFresh87
Frequent Visitor
2 years ago

Do you know why this was the case? I know this is an old issue and probably not in your head, but I am curious.