DataFormat.Error: Invalid cell value '#NAME?'.

[Anonymous]

Hi,

I get this error when trying to identify duplicates from a column called "Full Name". There is no value there with  '#NAME?' so I cannot seem to remove it too. Any suggestions are greatly appreciated.

Cheers

[v-chuncz-msft · Accepted solution]

@Anonymous ,

You'll need to correct the source file.

• https://community.powerbi.com/t5/Desktop/quot-OLE-DB-or-ODBC-error-dataformat-error-invalid-cell-value/m-p/189057#M83180
• https://support.office.com/en-us/article/How-to-correct-a-NAME-error-b6d54e31-a743-4d7d-9b61-40002a7b4286