Forum Discussion

Analitika's avatar
Analitika
Icon for Post Prodigy rankPost Prodigy
3 years ago

Error in column DataFormat.Error: Invalid cell value '#N/A'. in Power BI

Hello,

 

How to resolve this DataFormat.Error: Invalid cell value '#N/A'. in power bi na is  all values but when I look at excel I see not only na but correct values. So how to resolve this issue?

Need Help

1 Reply

  • PhilipTreacy's avatar
    PhilipTreacy
    Icon for Super User rankSuper User
    3 years ago

    Hi Analitika 

     

    What you are asking isn't entirely clear.  It's always best to provide sample data to explain your situation.

     

    Are you saying all the data you've imported is showing this error?  

     

    "in power bi na is  all values"

     

    Do you want to fix the error(s) in Excel before import, or do you want to get rid of the errors after import?

     

    If you have an error like #N/A in Excel, it will load into Power Query as an Error in the column.  Can't you just remove the errors by right clicking the column header and choosing 'Remove Errors'?

     

    Regards

     

    Phil