Forum Discussion
Syndicate_Admin
Administrator
2 years agoPower BI Desktop dynamic connect, can't connect additional data sources
I've come across discussions stating that in Power BI Desktop's dynamic connect mode, it's not possible to connect to additional data sources. Can anyone confirm if it can still be the case that othe...
- 2 years ago
You can convert a Live Connection to DirectQuery and add DirectQuery or Import sources. The result is a composite model (explained below). Navigate to Modeling --> Make changes to this model. There's also a link "Make changes to this model" at the bottom right of Power BI Desktop.
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models
DataInsights
Super User
2 years ago
You can convert a Live Connection to DirectQuery and add DirectQuery or Import sources. The result is a composite model (explained below). Navigate to Modeling --> Make changes to this model. There's also a link "Make changes to this model" at the bottom right of Power BI Desktop.
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models