Forum Discussion
#N/A Value in Excel File
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 _ xiaosunIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.
Thanks v-xiaosun-msft! This worked.
