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 recognizes some of the rows as dates but kicks out the above error. I have made sure I am in the right region.

I can convert the text type into date in excel with no problems.

Below is some sample data from a few data fields with nulls removed

 

Development Test End DateDevelopment Test Start DateStage End DateStage Start DateTest End DateTest Start DateDevelopment End DateDevelopment Start Date
4/9/20214/7/2021    4/6/20214/6/2021
6/16/20206/16/20206/19/20206/19/20206/18/20206/17/20206/15/20206/11/2020
3/28/20203/28/20203/26/20203/26/20203/26/20203/26/20203/28/20203/27/2020
1/21/20211/21/2021      
6/16/20206/15/20206/22/20206/19/20206/18/20206/17/20206/12/20206/10/2020
6/10/20206/9/2020      
7/20/20207/20/20207/23/20207/23/20207/21/20207/21/20207/17/20207/16/2020
12/16/202012/10/2020    12/9/202012/3/2020
2/9/20212/2/2021    2/1/20211/28/2021
8/26/20208/26/20209/17/20209/4/20209/3/20209/2/20208/25/20208/19/2020
4/29/20214/5/2021    4/2/20213/30/2021
4/21/20214/19/2021      
2/1/20211/29/2021      
2/1/20211/29/2021      
3/28/20203/26/20203/31/20203/30/20203/30/20203/28/20203/26/20203/24/2020
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.

     

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    The data did not show up correctly here is a screenshot of data from PBI.

     

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