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.

Share This:
Twitter
Facebook
LinkedIn

Stay up to date with the latest customer data news, expert guidance, and resources.

Iteration and Error Handling in M Query

All iteration roads in M Query eventually lead to the List.Generate function. In strengthening our data manipulation skills through Power Query, we absolutely need this looping function.

More Resources

Trusted By Over 6 Million End Users​

Industry leaders and over 6 million end users choose SkyPoint as their comprehensive and compliant Modern Data Stack Platform. A Gold Certified Microsoft Partner, SkyPoint Cloud turns siloed customer data into connected customer experiences.