Forum Discussion
DataFormat.Error: We couldn't parse the input provided as a DateTime value.
Hi Anonymous
The date format for your original is “mm/dd/yyyy” and everything seems normal . When you create a linked table to your bronce dataflow , the date format appears to be converted to “dd/mm/yyyy” , but in fact it is still "mm/dd/yyyy" , in the case where the day and month positions are converted, but the format is not converted, once the number of day is greater than 12, an error will occur, because there are only 12 months in a year.
You can use Replace value in Power Query Editor to change the day and month positions and then change the date format .
Best Regard
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous
The date format for your original is “mm/dd/yyyy” and everything seems normal . When you create a linked table to your bronce dataflow , the date format appears to be converted to “dd/mm/yyyy” , but in fact it is still "mm/dd/yyyy" , in the case where the day and month positions are converted, but the format is not converted, once the number of day is greater than 12, an error will occur, because there are only 12 months in a year.
You can use Replace value in Power Query Editor to change the day and month positions and then change the date format .
Best Regard
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.