Forum Discussion

EEEhernan8's avatar
EEEhernan8
Regular Visitor
4 years ago
Solved

ERROR #VALUE! EN POWER QUERY

En Power Query me marcan algunas celdas con ERROR, el error es que no acepta los datos bajo un formato de fecha y hora debido a que el valor de la celda es #VALUE!, como se observa en la siguiente im...
Need Help
  • jbwtp's avatar
    jbwtp
    4 years ago

    Hi EEEhernan8,

     

    This must be en error in the Excel file. Check your input data.

    If you can't see it in the Excel file. Convert the data into csv and then try again from the csv file to see where it fails.

     

    Kind regards,

    John

jbwtp's avatar
jbwtp
Icon for Memorable Member rankMemorable Member
4 years ago

Hi EEEhernan8,

 

This must be en error in the Excel file. Check your input data.

If you can't see it in the Excel file. Convert the data into csv and then try again from the csv file to see where it fails.

 

Kind regards,

John