Summary

In this chapter, we came closer to the end of our journey of performance optimization in Power BI. We focused on the reserved capacities that are available as Power BI Premium, Embedded, and Fabric offerings. We learned that you could purchase and license the offerings differently, but that they share more functionality across SKUs. This means that the same performance optimization guidance applies to capacities consistently.

We introduced Fabric capacities that are set to replace Premium as of the printing of this book. We learned that there are still improvements that Premium brought to the table that are improved in Fabric when using large semantic models. After that, we looked at capacity settings such as query timeouts and refresh intervals, which you can use to prevent expensive operations from severely affecting the capacity.

Then, we discussed how capacities have different ways of evaluating capacity load. The memory limits we listed by capacity and options for...