Forum Discussion

newpbiuser01's avatar
newpbiuser01
Helper V
3 years ago
Solved

#N/A Value in Excel File

Hello, I have a data table that's being imported from an excel file that will be updated on a monthly basis. Occasionally, the email field contains - #N/A as the value which throws an error when the...
Need Help
  • v-xiaosun-msft's avatar
    v-xiaosun-msft
    3 years ago

    Hi newpbiuser01 ,

     

    When you import your excel files to Power BI Desktop and edit it in Power Query, "#N/A" will show as "error".

    Expand the errors, you may see the message as below.

    When encountering any cell-level errors, Power Query provides a set of functions to handle them either by removing, replacing, or keeping the errors.

    You can try to remove the errors.

    Or you can select "replace errors".

    Please reference the following document which will be helpful to you.

    Dealing with errors - Power Query | Microsoft Learn

     

    Best Regards,
    Community Support Team _ xiaosun

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.