Working with connection modes
When we get data from a data source, the query connection mode falls into one of the following three different categories:
- Data Import
- DirectQuery
- Connect Live
Every query connecting to one or more data sources in the Power Query Editor has any of the preceding connection modes, except Connect Live. When the connection mode is Connect Live, a Power BI model cannot currently connect to more than one instance of SSAS, AAS, or a Power BI dataset.
Note
Microsoft released the preview of the new version of the composite models in December 2020. With the new version of composite models, we can DirectQuery to more than one instance of AAS or Power BI datasets. The new composite models currently do not support SSAS Tabular. We will discuss composite models in more detail in Chapter 12, Extra Options and Features Available for Data Modeling.
In this section, we look at the connection modes, their applications, and their limitations...
