© Reza Rad 2018
Reza RadPro Power BI Architecturehttps://doi.org/10.1007/978-1-4842-4015-1_7

7. Live Connection

Reza Rad1 
Meadowbank, Auckland, New Zealand

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. ...

Get Pro Power BI Architecture: Sharing, Security, and Deployment Options for Microsoft Power BI Solutions now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.