Forum Discussion

MikeO's avatar
MikeO
Icon for Helper I rankHelper I
9 years ago
Solved

Invalid cell value '#NAME?'

I am connected to a single table in a Microsoft Excel sheet and I am receiving the following error after PowerBI attempts to apply query changes: [DataFormat.Error] Invalid cell value '#NAME?'   If...
  • v-chuncz-msft's avatar
    v-chuncz-msft
    9 years ago

    MikeO,

     

    It seems that you have already solved this problem here. Any further question, feel free to raise a new thread.

MikeO's avatar
MikeO
Icon for Helper I rankHelper I
9 years ago

I am connected to a single table in a Microsoft Excel sheet and I am receiving the following error after PowerBI attempts to apply query changes: [DataFormat.Error] Invalid cell value '#NAME?'

 

If I go into Edit Queries and Remove Errors, the whole table goes away and the same DataFormat.Error pops up until I delete that step.