Forum Discussion
Combination of DirectQuery and Import
What is the impact when one opts to use a combination of DirectQuery and Import (SQL Server Data Source)? How does Power BI handle such a combination?
Hi Anonymous ,
Based on my research, you may refer to below links for further information:
https://docs.microsoft.com/en-us/power-bi/desktop-composite-models#use-composite-models
https://www.linkedin.com/pulse/composite-model-power-bi-who-wants-part-evolution-jakub-barzyk
Regards,
Daniel He
2 Replies
Hi Anonymous ,
Based on my research, you may refer to below links for further information:
https://docs.microsoft.com/en-us/power-bi/desktop-composite-models#use-composite-models
https://www.linkedin.com/pulse/composite-model-power-bi-who-wants-part-evolution-jakub-barzyk
Regards,
Daniel He
Great links - thank you! My main takeaway was this one, which was causing the behaviour I was noticing. When using a composite model, a sluggish performance may result on the Service side.
"Using composite models adds additional performance considerations. A single visual can result in sending queries to multiple sources, which often pass the results from one query across to a second source."