Reid Havens

Reid Havens

Reid is the Founder of Havens Consulting Inc. He has a formal background in technology and organizational management, having obtained separate Master's Degrees in Organizational Development & Business Analytics. Reid has experience working with many of the Fortune 50, 100, & 500 companies. Additionally he guest lectures at the University of Washington and other universities, teaching Business Intelligence, Reporting, & Data Visualization. Reid is also an avid content developer, having authored numerous articles and videos on various blog sites and video platforms. He's also written multiple training curriculum's for PowerPivotPro, and taught them as a Principal Consultant at dozens of companies around the world. He also developed college level classes for Bellevue College and The University of Washington. Reid is also currently developing multiple online video series on Learning & Mastering Power BI for the Packt Publishing Company.

Founder | BI Evangelist - Havens Consulting


(Login to save favorite sessions)

Performance, Optimization, and Intelligent Error Handling in Power Query

There are two cornerstones to building optimized and low maintenance queries in Power BI. The first is making sure queries have been designed to refresh at optimal speeds. Primary topics for performance tuning include: removing columns and rows, applied step configuration and order precedence, query folding, managing variables, and tables vs lists for transformations. The other important cornerstone is intelligently identifying and handling errors as they occur during scheduled refreshes. Primary topics for error handling include: replacing vs removing errors, collecting error metadata, and configuring the refresh to either fail or refresh successfully when errors occur.

Van Halen
3:15 PM
Live session URL