Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi All,
I have a data set with a frustrating issue where some dates are throwing errors :
DataFormat.Error: We couldn't parse the input provided as a Date value.
I have checked there are no rogue spaces or characters in the data set and are indeed consistent d/mm/yyyy throughout the column.
What is even weirder is that when i create a separate powerBi file and query the same table with the EXACT same M code, there are no errors, and the column recognises the dates.
Original Error:
Separate new blank PBI, Exact same M code copied and pasted into advanced editor... no errors:
What could be causing this issue??
Solved! Go to Solution.
@awff , if you system is having US date format, then it might give issue with UK date format
of do conversion
DD/MM/YYYY to MM/DD/YYYY
date(year( right(DD__MM__YY[date],4)), month(mid(DD__MM__YY[date],4,2)) ,day(left(DD__MM__YY[date],2)))
Power Query - Text.Start, Text.Middle, Text.End: https://www.youtube.com/watch?v=vky4wPqm0O0
@awff , if you system is having US date format, then it might give issue with UK date format
of do conversion
DD/MM/YYYY to MM/DD/YYYY
date(year( right(DD__MM__YY[date],4)), month(mid(DD__MM__YY[date],4,2)) ,day(left(DD__MM__YY[date],2)))
Power Query - Text.Start, Text.Middle, Text.End: https://www.youtube.com/watch?v=vky4wPqm0O0
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
65 | |
64 | |
56 | |
39 | |
27 |
User | Count |
---|---|
85 | |
59 | |
45 | |
43 | |
38 |