Forum Discussion
Data Format Error: We couldn't parse the input provided as a Date value
I had the same problem when I used the "Group By" feature in Power Query. I then paid attention to the error which mentions below that "Data Format Error: We couldn't parse the input provided as a Date value" sentence which states "Error: "-"", that made me realize certain cells had dashes ("-") instead of zeros or nulls. Once I replaced those dashes to zeros or nulls, it worked fine.
Hope that helps you and anyone in this thread facing this problem!
En power query tenía el siguiente caso:
Me conecté a una carpeta que tenia varios archivos.
cada archivo tiene sus propios encabezados
Al promover primera fila como encabezados, quedaron varios de los titulos en el proceso
Lo que hice fue ir a la columna de fecha, y eliminar filas con errores.
Asunto solucionado.
In power query I had the following case:
I connected to a folder that had several files.
each file has its own headers
By promoting first row as headlines, several of the titles were left in the process
What I did was go to the date column, and remove rows with errors.
Issue resolved!!
