Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
DeanNSP
Regular Visitor

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

6 REPLIES 6
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

 

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.

thanks a lot, it works

It works with me. Thank you for the solution.

DeanNSP
Regular Visitor

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

DeanNSP_0-1643390567870.png

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.