A Power BI model contains a Sales fact table with 500 million rows in Azure Synapse. The team wants fast interactive reports without importing data. Which connectivity approach provides the best query performance while keeping data in Synapse?

Question

Power BI — Hard

A Power BI model contains a Sales fact table with 500 million rows in Azure Synapse. The team wants fast interactive reports without importing data. Which connectivity approach provides the best query performance while keeping data in Synapse?

Accepted Answer

DirectQuery with aggregations and dual-mode dimension tables optimizes query performance by minimizing data transfer. This approach enables fast interactive reports without importing data. It leverages Synapse's capabilities while reducing latency.