Exception Reporting in Power Query and Power BI; Part 2 Catching Error Rows for All Columns in a Table Section 1

Previously, I have written about using Power Query transformations and functions to create an Exception report for Power BI. However, the method I mentioned there, was only doing the exception handling based on one column. In this article, I’m explaining how to do exception reporting for all columns in the entire table. There are a little bit more steps and also learnings when you do the whole process for the entire table. To learn more about Power BI, read Power BI book from Rookie to Rock Star.

Read the rest of the article here: https://radacad.com/exception-reporting-in-power-query-and-power-bi-part-2-catching-error-rows-for-all-columns-in-the-table-section-1