Learn How to Track Errors with a Power Query Error Table

MARK WALTER (Industrial Finishes and Systems) – Learn How to Track Errors with a Power Query Error Table

Power Query is a remarkable ETL tool within Power BI; however it is all too easy to overlook errors that might be buried within our data. In this session, Mark will demonstrate a practical solution learned from Reza Rad (PASS Summit 2019) that combines Power Query transformations, and Power BI visuals to help better track and address root causes of errors as they arise in our dataset.

Mark is an Accounting and Analytics Manager at IFS. Since 1958, Industrial Finishes and Systems, Inc. (IFS), a Nationwide distributor, has brought complete system solutions to Auto Body Shops, RV manufactures, Wood product producers, and Aerospace industries. He is originally from Honolulu Hawaii but lived much of his adult life in the Seattle area where he majored in Finance and Accounting. Mark is an long time Excel power user, and today focuses on DAX/M and promoting a data driven culture. Mark enjoys speaking locally with networking and professional groups, helping to promote and build awareness of Power BI in the workplace.

Visit Mark’s BI blog for more of his tutorials:

May 2020 Meetup – Portland Power BI User Group on 5/27/20

The Portland Power BI User Group (Portland Power BI UG) is a community of people excited about Microsoft’s business analytics tool, Power BI. We believe the platform offers rich possibilities, and we keep pace by sharing our learning and doing deep-dive explorations of topics. We run the gamut from new to experienced users and welcome anyone who shares an interest in data analytics.

Portland Power BI UG is organized and hosted by local BI consulting firm CSG Pro ;

Visit the community at: www.pbiusergroup.com/portland

Check out our amazing sponsors:
Lexicon Solutions –
Aldrich Technology –
Black Bulb Creative –


3 thoughts on “Learn How to Track Errors with a Power Query Error Table”

  1. Fantastic video. Do you think youtube is Good for small creators? Also, Can we Be youtube friends? xD

  2. Really good. I have a question: if you want to keep those errors (alphanumeric) into the column as same as it was, then you have to click on which option in power query?

Leave a Reply

Your email address will not be published.

Related Post