Tag: Exception Reporting

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

Posted on by Reza Rad

In the first part of this series, you learned how to create an exception reporting for a column in a table using Power Query in Power BI. In the second part, you learned how to initiate that process for all columns in a table. This article continues the section one of creating exception reporting for Read more about Exception Reporting in Power Query and Power BI; Part 2 Catching Error Rows for All Columns in the Table Section 2[…]

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

Posted on by Reza Rad

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 Read more about Exception Reporting in Power Query and Power BI; Part 2 Catching Error Rows for All Columns in the Table Section 1[…]