A team asks for DirectQuery because the sales data changes frequently. How would you decide whether it is appropriate?

Instruction: Supply a freshness requirement you can explain, such as daily management reporting or a defined operational interval. Do not invent a benchmark or claim a connector supports a mode without checking it.

Context: Makes freshness measurable, considers source workload, and proposes appropriate alternatives without treating one storage mode as universally superior.

Updated

Official answer available

Read the opening below, then unlock the full answer and practical guidance.

I'd ask how fresh the numbers actually need to be, how many people will use the report, and how quickly the source can answer typical filtered queries...

Upgrade to view official answer

Related Questions