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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
nyamz
New Member

Power Query

Hi, iam getting this error when i close and apply kindly help
DataFormat.Error: We couldn't parse the input provided as a Date value. Details: 13-01-2015

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi nyamz,
To fix the DataFormat.Error: We couldn't parse the input provided as a Date value.
Details: 13-01-2015 in Power BI Power Query,


follow these steps:

 

1. Check Date Format:
Ensure the date format in the dataset matches the expected format in Power Query. The date '13-01-2015' suggests a 'dd-MM-yyyy' format.

 

2. Change Data Type:
- Go to the column causing the issue.
- Right-click and select `Change Type` -> `Using Locale`.
- Choose Date and select the appropriate locale (e.g., `English (United Kingdom) for 'dd-MM-yyyy').

 

3. Transform Column:
If the dates are in text format, use a custom column to transform them into the correct date format:
= Date.FromText(Text.Replace([YourDateColumn], "-", "/"))

 

4. Other Possibilities:
- Mixed data types in the column (example, text and dates).
- Inconsistent date formats within the same column.
- Empty or null values in the date column.
- Incorrect regional settings in Power BI.

 

These steps should help resolve the parsing error.
Ensure no other non-date values exist in the column to avoid issues.

 

Regards,
Chiranjeevi Kudupudi

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Hi @nyamz ,

 


Did @ChielFaber , @Anonymous 's answers help you? If so, consider marking the responses that helped you as solutions!

If the question is not resolved, could you consider posting some sample data and code or screenshots of the conversion steps?
You can find the corresponding step-by-step code in the advanced editor, please be sure to delete the private information before posting.

vcgaomsft_0-1721714662951.png
How to provide sample data in the Power BI Forum - Microsoft Fabric Community
How to Get Your Question Answered Quickly - Microsoft Fabric Community

Best Regards,
Gao

Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

Anonymous
Not applicable

Hi nyamz,
To fix the DataFormat.Error: We couldn't parse the input provided as a Date value.
Details: 13-01-2015 in Power BI Power Query,


follow these steps:

 

1. Check Date Format:
Ensure the date format in the dataset matches the expected format in Power Query. The date '13-01-2015' suggests a 'dd-MM-yyyy' format.

 

2. Change Data Type:
- Go to the column causing the issue.
- Right-click and select `Change Type` -> `Using Locale`.
- Choose Date and select the appropriate locale (e.g., `English (United Kingdom) for 'dd-MM-yyyy').

 

3. Transform Column:
If the dates are in text format, use a custom column to transform them into the correct date format:
= Date.FromText(Text.Replace([YourDateColumn], "-", "/"))

 

4. Other Possibilities:
- Mixed data types in the column (example, text and dates).
- Inconsistent date formats within the same column.
- Empty or null values in the date column.
- Incorrect regional settings in Power BI.

 

These steps should help resolve the parsing error.
Ensure no other non-date values exist in the column to avoid issues.

 

Regards,
Chiranjeevi Kudupudi

ChielFaber
Solution Supplier
Solution Supplier

Could you provide sample data? This error would occur when converting values into a date type. Look into the use of a locale:

https://learn.microsoft.com/en-us/powerquery-m/date-from
https://www.vivran.in/post/power-query-date-transformation-using-locale-text-to-date

Depending on your location settings a date value can be converted differently. You can solve this with the use of a locale.

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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

Top Solution Authors