Avoiding Pitfalls in Reporting: Lessons from the Trenches

Reid Havens

In this session, we will explore best practices for auditing, repairing, and optimizing Power BI PBIX files. Drawing on my experience of building over 100 reports and data models for clients over the past decade, I will share with you the patterns, mistakes, and pitfalls that I have identified. You will learn how to identify common issues in Power Query queries, modeling, relationships, DAX, and report design, and how to apply a toolset of best practices to address them. By following these best practices, you can significantly improve the performance and user experience of your Power BI reports, including reducing file size, improving load and calculation speed, and providing a cleaner interface for end-users.