dutchdatadude.com
Power BI Pro Tip: Dealing with errors when reading Excel files
If you use Power Query to read an Excel file that has errors (such as #VALUE, #REF, #N/A, etc) the rows that contain the error will not be loaded into the data model but instead will be flagged as …