Power BI Premium features

This article lists the main Power BI Premium features. Most of the features apply to all the Power BI Premium licenses, Premium Gen2, Premium (original version) and Premium Per User (PPU) as well as Power BI Embedded. When a feature only works with a specific license, the required license is indicated in the description field. If no license is listed, the feature works with any license.


If your organization is using the original version of Power BI Premium, you're required to migrate to the modern Premium Gen2 platform. Microsoft began migrating all Premium capacities to Gen2. If you have a Premium capacity that requires migrating, you’ll receive an email notification 60 days before the migration is scheduled to start. For more information see Plan your transition to Power BI Premium Gen2.

Power BI Premium feature list

Feature Description
Advanced AI Use artificial intelligence (AI) with dataflows
Asynchronous refresh Perform asynchronous data-refresh operations
Automatic aggregations Optimize DirectQuery datasets
Autoscale Automatically add compute capability when your capacity is overloaded

Available for Premium Gen2 only
Backup and restore Backup and restore data using XMLA endpoints
Bring your own key (BYOK) Use your own keys to encrypt data

Available for Premium Gen2, Premium (original version), and Embedded
Datamarts Self-service solution enabling users to store and explore data that's loaded in a fully managed database
Deployment pipelines Manage the lifecycle of your Power BI content
DirectQuery with dataflows Connect directly to your dataflow without having to import its data
Hybrid tables (preview) Incremental refresh augmented with real-time data
Insights (preview) Explore and find insights such as anomalies and trends in your reports
Model size limit Available memory is set to:

Premium Gen2 - The limit of memory footprint of a single Power BI item; see the column Max memory per dataset in the Capacities and SKUs table

Premium (original version) - The cumulative consumption of memory of the capacity; see the column RAM in the table at the bottom of Capacity nodes

Premium Per User (PPU) - See Considerations and limitations

Embedded - See the column Max memory per dataset in the SKU memory and computing power table
Multi-geo Deploy content to data centers in regions other than the home region of your tenant

Available for Premium Gen2, Premium (original version), and Embedded
On-demand loading capabilities for large models Improve report load time by loading datasets to memory on demand
Power BI Report Server On-premises report server

Available for Premium Gen2 and Premium (original version)
Refresh rate The ability to refresh more than eight times a day
Query caching Speed up reports by using local caching
Storage Manage data storage
Streaming dataflows (preview) Connect to, ingest, mash up, model, and build reports using near real-time data
Unlimited content sharing Share Power BI content with anyone

Available for Premium Gen2 and Premium (original version)
Virtual network data gateway (preview) Connect from Microsoft Cloud to Azure using a virtual network (VNet)
XMLA read/write Enable XMLA endpoint

Next steps