Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Super User
Super User

PQ error handling #N/A

I am building a BI based on an excel file submitted by the data entry operators (upon which I have no control).


The file contains columns with #N/A values in some of the columns. I also don't know beforehand/ control on which column these values might end up.


Whenever there is #N/A in any of the columns the BI breaks. What is the most efficient way of handiling #N/A without requiring the data entry operators to make necessary adjustments while submitting the file.


I tried try..otherwise but it does not seem to work.



@ImkeF @AlexisOlson 

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs
Community Support
Community Support

Hi, @smpa01 ;

there are 2 options "remove errors" and "replace error" in Power Query Editor

Right-click to columns that contains errors and choose appropriate option.


The final show:


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Super User
Super User

Can you provide a dummy file with input and desired output?

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors
Top Kudoed Authors