© 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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.