cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DeanNSP
New Member

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
1 ACCEPTED SOLUTION

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

DeanNSP_0-1643736264381.png

 

View solution in original post

3 REPLIES 3
v-xiaotang
Community Support
Community Support

Hi @DeanNSP 

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

My operation process:

1. format data in Excel

vxiaotang_1-1643694238190.png

2. get data from excel in Power BI Desktop.

vxiaotang_0-1643692917809.png

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.

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

DeanNSP_0-1643736264381.png

 

DeanNSP
New Member

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

DeanNSP_0-1643390567870.png

 

Helpful resources

Announcements
Power BI Show Ep 4 Post Show Carousel.jpg

The Power BI Community Show

Shabnam Watson demos Incremental refresh & Hybrid Tables and Leila Etaati demos Charticulator.

PBI April Release 2022 768x460.png

Check it out!

Click here to read more about the April 2022 updates!

Power BI Dev Camp Session 22 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!