Summary

In this chapter, we introduced some popular utilities that use different methods to analyze Power BI solutions and help us identify areas to improve. One caveat is that free versions of these tools are often community projects and are not officially supported. DAX Studio and Tabular Editor have been widely adopted by the Power BI community and are continuously updated as of the publication of this book.

We learned about Power BI Helper’s ability to document large dictionary columns and relationships and measure dependencies. Next, we learned about Tabular Editor’s BPA. This gave us an easy way to load in default rules provided by experts, and then scan a semantic model for best practices.

DAX Studio is a complete query development and tuning utility that can capture real-time query activity and timings. We learned how to generate model metrics that give us detailed information about the objects and how much space they occupy. We then moved on to query timings...