Forum Discussion
[DataFormat.Error]
hello
i pivot columns of my datast in power query.
When i accept modifaication, i have this error message: An OLE DB or ODBC error: [DataFormat.Error] Sorry... We could not parse the provided input to a Date value.. An unexpected error occurred.
I do'n't have date column in my table.
Someone can help me!
Hi carolez
Thank you wardy912, for you insights
Even if your table doesn’t show a date column, this error can happen because Power Query sometimes treats certain values, like column headers or those created during pivoting, as dates.Below is the solved link to your issue:
Solved: "We couldn't parse the input provided as a Date va... - Microsoft Fabric CommunityHope this helps
Thank you.
5 Replies
Hi carolez
Do you have any columns that contain values that look like dates (e.g., "01/02", "2023-04", etc.)? Power query will try to convert them automatically which may be causing the error. After pivoting manually set the columns to text.
The same could apply to column headers. In this case before pivoting, prefix the columns with 'col_'.
I hope this helps, please give a thumbs up and mark as solved if it does, thanks!
Hi carolez
Thank you wardy912, for you insights
Even if your table doesn’t show a date column, this error can happen because Power Query sometimes treats certain values, like column headers or those created during pivoting, as dates.Below is the solved link to your issue:
Solved: "We couldn't parse the input provided as a Date va... - Microsoft Fabric CommunityHope this helps
Thank you.
Hi carolez,
Have you had a chance to review the solution we shared earlier? If the issue persists, feel free to reply so we can help further.
Thank you.
Hi carolez,
Checking in to see if your issue has been resolved. let us know if you still need any assistance.
Thank you.
Hi carolez,
We haven’t heard back from you in a while regarding your issue. let us know if your issue has been resolved or if you still require support.
Thank you.
