Exploring Power BI Helper
Power BI Helper has a range of features that help you explore, document, and compare local Power BI Desktop files. It also lets you explore and export metadata from the Power BI service, such as lists of workspaces and semantic models plus their properties. Power BI Helper can be downloaded from the following link: https://powerbihelper.org and is hosted by RADACAD. RADACAD is a consulting company out of New Zealand that has a wealth of Power BI information online at https://radacad.com/.
In previous chapters, we discussed how important it is to keep Power BI semantic models smaller by removing unused tables and columns. Power BI Helper includes features to help you find these unused objects, so it could be a useful tool to incorporate into standard optimization processes before production releases.
Identifying large column dictionaries
In general, having a smaller model speeds up report loads and data refreshes, which is why it is good to be able...
