Using Autoscale with Power BI Premium
Power BI Premium offers scale and performance for Power BI content in your organization. With Power BI Premium Gen2 (Preview), many improvements are introduced including enhanced performance, greater scale, improved metrics. In addition, Premium Gen2 enables customers to automatically add compute capacity to avoid slowdowns under heavy use, using Autoscale.
Autoscale uses an Azure subscription to automatically use more v-cores (virtual CPU cores) when the computing load on your Power BI Premium subscription would otherwise be slowed by its capacity. This article describes the steps necessary to get Autoscale working for your Power BI Premium subscription. Autoscale only works with Power BI Premium Gen2.
To enable Autoscale, the following steps need to be completed:
- Select and configure an Azure subscription to use with Autoscale
- Configure Power BI Premium to use the selected Azure subscription for Autoscale
The following sections describe the steps in detail.
Configure an Azure subscription to use with Autoscale
To select and configure an Azure subscription to work with Autoscale, you need to have contributor rights for the selected Azure subscription. Any user with Account admin rights for the Azure subscription can add a user as a contributor. In addition, you must be an admin for the Power BI tenant to enable Autoscale.
To select an Azure subscription to work with Autoscale, take the following steps:
Log into the Azure portal and select Subscriptions from the left pane. In the following image, the highlighted subscription is called Pay-As-You-Go.
Select a subscription. Once selected, you need to create a Resource group to use with Autoscale. Select Resource group from the Settings selections for your selected subscription. Then select the Add button to create a new Resource group.
The Create a resource group window appears, where you can name the resource group. In the following image, the resource group is called powerBIPremiumAutoscaleCores. You can name your resource group whatever you prefer. Just remember the name of the subscription, and the name of your resource group, since you'll need to select it again when you configure Autoscale in the Power BI Admin Portal.
When you're satisfied with the name of the resource group, select the Review + create button in the bottom left corner of the portal pane. Azure validates the information, after which you select the Create button to create the resource group. Once created, you receive a notification in the upper-right corner of the Azure portal, similar to the following:
Okay, you've selected the Subscription in the Azure portal that you'll use for Autoscale, and created a Resource group for that subscription. The next step is to enable Autoscale in the Power BI Admin portal, and link it to the resource group you just created.
Considerations for preview release
When Autoscale is launched in preview, a window to enable customers to become accustomed to the usage levels and CPU core utilization is being provided. During the initial window, charges to the configured Azure subscription used for Autoscale will not be applied. That window is anticipated to be 30 days. The best way to become accustomed to the level of usage your organization is to sign up for utilization alert notifications in the Power BI Admin portal, and to monitor alerts for utilization levels.
Paginated Reports are not included in the process of determining the level of utilization, and whether to Autoscale, during initial window.
Enable Autoscale in the Power BI Admin portal
Once you've selected the Azure subscription to use with Autoscale, and created a resource group as described in the previous section, you're ready to enable Autoscale and associate it with the resource group you created. The person configuring Autoscale must be at least a contributor for the Azure subscription to successfully complete these steps. You can learn more about assigning a user to a contributor role for an Azure subscription.
The following steps show you how to enable and associated Autoscale with the resource group.
Open the Power BI Admin portal and select Capacity settings from the left pane. Information about your Power BI Premium capacity is displayed.
Autoscale only works with Power BI Premium Gen2 (Preview). Enabling Gen2 is easy: just move the slider to Enabled in the Premium Generation 2 (preview) box.
Select the Manage auto-scale button to enable and configure Autoscale, and the Auto-scale settings pane appears. Select the Enable auto scale.
You can then select the Azure subscription to use with Autoscale. Only subscriptions available to the current user are displayed, which is why you must be at least a contributor for the subscription. Once your subscription is selected, select the Resource group you created in the previous section, from the list of resource groups available to the subscription.
Next, assign the maximum number of v-cores to use for Autoscale, and then select Save to save your settings. Power BI applies your changes, then closes the pane and returns the view to Capacity settings, where you can see your settings have been applied. In the following image, there were a maximum of two v-cores configured for Autoscale.
Here's a short video that shows how quickly you can configure Autoscale for Power BI Premium Gen2:
And that's it - your Power BI Premium Gen2 subscription is now configured to use Autoscale, so users in your organization automatically get the responsiveness they need from their Power BI content and insights, even under periods of heavy use.