I'm working on a project right now where I need to describe on a high-level when to use the Import versus DirectQuery connection mode within Power BI. Like many of things, this decision is a tradeoff ...