Forum Discussion

RenataOG30s's avatar
RenataOG30s
Frequent Visitor
4 years ago
Solved

DataFormat Error

Hi all,   I'm getting the error below when I try to refresh my data. Can you help me with this, please?   DataFormat.Error: Invalid cell value '#N/A'.   Thanks, R.
  • Pragati11's avatar
    4 years ago

    HI RenataOG30s ,

     

    In your new data you are having  '#N/A' value in one of your columns which ideally shouldn't have it.

    Data Format error generally gives more details. Try checking at.

    Also, start checking specially with the columns in your data that are not expected to have such value like primary key column used to create relationship with other tables, date columns, numeric columns, etc.

     

    Also, it will be nice to have some more details on the issue. Just the error message doesn't help in understanding the issue properly.

    https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

     

    Thanks,

    Pragati