Query scale-out

Important

This content is archived and is not being updated. For the latest documentation, go to What's new in Power BI?. For the latest release plans, go to Dynamics 365 and Microsoft Power Platform release plans.

Enabled for Public preview General availability
Admins, makers, marketers, or analysts, automatically Jan 18, 2023 -

Business value

Support high user-concurrency workloads for large-scale deployments of semantic models (datasets) in Power BI Premium. Management of query scale out in Power BI Premium is largely automated for customers.

Feature details

Query scale-out in Power BI Premium enables user queries to be load balanced across multiple dataset read replicas in a pool of Power BI Premium Gen2 nodes. This speeds up query response times for high user-concurrency workloads.

Additionally, dataset refresh operations enjoy increased isolation from the read replicas to protect user queries and improve performance.

Management of query scale-out in Power BI Premium is highly automated compared to other platforms, such as Azure Analysis Services. Adding and removing read replicas is performed dynamically based on usage.

Query scale out architecture

See also

Power BI Dataset Scale-Out (docs)