Working with connection modes
- Data Import
- 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.
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.