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.
Demonstrate methods and best practices that align with business and technical requirements for modeling, visualizing, and analyzing data with Microsoft Power BI.