Power Query

[nyamz]

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

[v-cgao-msft]

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.

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 · Accepted solution]

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]

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.