Forum Discussion
[DataFormat.Error]
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
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!