[DataFormat.Error]

[carolez]

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!

[v-saisrao-msft]

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.

[v-saisrao-msft]

Hi @carolez,

Checking in to see if your issue has been resolved. let us know if you still need any assistance.

Thank you.

[v-saisrao-msft]

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.

[v-saisrao-msft · Accepted solution]

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 Community

Hope this helps

Thank you.

[wardy912]

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!