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.

     

v-xiaotang's avatar
v-xiaotang
Community Support
4 years ago

Hi Anonymous 

I test it with your sample data, and it works fine on my side.

My operation process:

1. format data in Excel

2. get data from excel in Power BI Desktop.

Does it work if you try the same operation?

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

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.

 

  • MohamedMufid's avatar
    MohamedMufid
    New Member
    2 years ago

    It works with me. Thank you for the solution.

  • Rahaf350's avatar
    Rahaf350
    New Member
    2 years ago

    thanks a lot, it works

  • 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.