Summary

In this chapter, we started with visualization optimization, covering into visual layouts and then slicer and interaction filtering. The busy report was mentioned, and some alternatives, such as drill-through reporting, were demonstrated. Edited interactions between visuals were used to stop some unnecessary filtering. Training was mentioned for end users selecting items in the filtering pane. A reminder was given about the potential negative impact of executing multiple queries on large semantic models.

The chapter switched to the other report types – dashboards and paginated reports. Dashboards are tiles from Power BI reports and the latter come from SSRS. Paginated reports are used for line-item types that are not good performance-wise for semantic model data. Dashboards enable visuals from different reports to be placed on one canvas.

All these types of scenarios have best practices for optimizing performance for end users. These ranged from using filters to...