Working with connection modes
When we connect to 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 one 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 or AAS, or a Power BI dataset. As mentioned earlier, in December 2020, Microsoft released the preview of the new version of the composite models in which we can connect to multiple Power BI Datasets or AAS/SSAS tabular 2022 models when using the DirectQuery mode. We discuss composite models in more detail in Chapter 14, DirectQuery Connections to Power BI Datasets and Analysis Services in Composite Models.
This section looks at the connection modes, their applications, and their limitations.
