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 k...