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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. 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
v-cgao-msft
Community Support
Community Support

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
Responsive Resident
Responsive Resident

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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