Live Connection is another type of connection in Power BI. This type of connection is somehow similar to DirectQuery because it won’t store data in memory. However, it is different from DirectQuery, because it will give you the analytical engine of SQL Server Analysis Services Tabular. With this method, you get benefits of both worlds: large-scale model size and the analytical power of Analysis Services. In this chapter, you’ll learn the details of this type of connection, things that you need to consider, and how to set it up working with a gateway.
This chapter focuses on Live Connection. ...