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

6. DirectQuery

Reza Rad1 
Meadowbank, Auckland, New Zealand

In the last chapter, you learned about Import Data as a connection type. In this chapter, you’ll learn about the second type of connection named DirectQuery. This type of connection is only supported by a limited number of data sources, and mainly targets systems with a huge amount of data. DirectQuery is different from another type of connection, which I’ll talk about in the next chapter, named Live Connection.

When a dataset is very large, loading data into Power BI might not be an option. Some data sources support a DirectQuery connection. In this chapter, you learn about this type of 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.