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