Power BI Premium vs Pro Licensing

Microsoft Power BI offers two primary licensing models: Power BI Pro and Power BI Premium. Pro is a per-user license that grants individual access to all Power BI service features, including creating and sharing dashboards, reports, and datasets. Premium, on the other hand, is a capacity-based license that reserves dedicated compute and storage resources in the Microsoft cloud. Understanding the difference is essential for the DP-900 exam because you will be asked to recommend the appropriate license based on organizational requirements such as number of users, need for dedicated capacity, or advanced features like AI and paginated reports.

Power BI Pro is a per-user subscription. Each user who wants to create or consume content in the Power BI service must have a Pro license. The license is purchased through Microsoft 365 admin center or Azure. Key characteristics: - Cost: Approximately $10 per user per month (as of 2025). - Content Creation: Pro users can create dashboards, reports, and datasets. - Content Consumption: Pro users can view content shared by other Pro users. - Sharing: Content can be shared with other Pro users within the same tenant. - Limitations: No dedicated capacity — all Pro users share the shared capacity pool. This means performance may degrade under high load. Maximum dataset size is 1 GB per dataset. Refresh limits: 8 scheduled refreshes per day for datasets. No support for paginated reports or AI-powered features like AutoML or cognitive services. - External Sharing: Pro users can share content with external Pro users if the tenant admin enables external sharing.

Power BI Premium is a capacity-based license. Instead of paying per user, you purchase a reserved capacity SKU (e.g., P1, P2, P3, or EM/PPU variants). This capacity provides dedicated compute and storage resources that are not shared with other tenants. Key characteristics: - Cost: Starting at approximately $4,995 per month for P1 (as of 2025). - Capacity SKUs: P1 (v-core 8, memory 25 GB), P2 (v-core 16, memory 50 GB), P3 (v-core 32, memory 100 GB), and higher. Also EM SKUs for embedding. - User Licensing: Users who create content still need a Pro license (or Premium Per User). However, users who only consume content (view dashboards and reports) do not need a Pro license — they only need a free Power BI license. This is a major exam point: Premium capacity allows free users to view content. - Features Exclusive to Premium: - Paginated Reports: Pixel-perfect, print-ready reports (SQL Server Reporting Services style). - AI Features: AutoML, cognitive services (text analytics, image tagging), and Azure Machine Learning integration. - XMLA Endpoints: Allows read/write access to datasets for advanced management. - Large Datasets: Up to 400 GB per dataset (P1) and larger with higher SKUs. - Increased Refresh Limits: 48 scheduled refreshes per day for datasets. - Deployment Pipelines: Manage lifecycle of content across dev, test, and production. - Multi-Geo Support: Store data in different geographic regions. - Performance: Dedicated capacity ensures consistent performance, no noisy neighbors. - Metrics App: Premium Capacity Metrics app to monitor resource usage.

Premium Per User (PPU) is a per-user license that grants the user access to Premium features without requiring the organization to purchase a full Premium capacity. Each PPU user pays a monthly fee (approximately $20/user/month) and gets the same features as Premium (paginated reports, AI, large datasets, etc.) but only for content that the PPU user creates or consumes. Other users who want to view that content must also have PPU licenses. PPU does not allow free users to view content. This is a common exam trap: PPU is per-user, not capacity-based, but includes Premium features.

The DP-900 exam expects you to evaluate scenarios: - Small team (<100 users): Pro is cost-effective. - Large organization (500+ users): Premium may be cheaper per user when considering free viewers. - Need for paginated reports or AI: Premium (or PPU) is required. - Need for dedicated performance or large datasets: Premium capacity. - External sharing to free users: Only Premium capacity allows this.

Licensing is managed in the Microsoft 365 admin center. To assign a Power BI Pro license: 1. Go to Microsoft 365 admin center > Users > Active users. 2. Select a user, click Licenses and apps, and assign Power BI Pro. 3. Alternatively, use PowerShell or Azure AD group-based licensing.

To enable Premium capacity: 1. Purchase a Premium SKU in Microsoft 365 or Azure. 2. In Power BI admin portal, manage capacity settings. 3. Assign workspaces to the capacity.

Verification commands (PowerShell):

# Get user licenses
Get-MsolUser -UserPrincipalName user@domain.com | Select-Object Licenses

# Check capacity assignments
Get-PowerBIWorkspace -Scope Organization -Include All | Where-Object {$_.CapacityId -ne $null}

Power BI licensing integrates with: - Microsoft 365: Pro licenses are managed via M365. - Azure Active Directory: For authentication and group-based licensing. - Azure Data Services: Premium capacity can connect to Azure SQL, Synapse, etc. - Power Platform: Power BI Pro licenses are separate from Power Apps or Power Automate licenses.

A common exam scenario: An organization wants to share dashboards with external stakeholders who do not have a Microsoft account. Answer: They need Power BI Premium capacity with the 'Share with external users' feature enabled, and external users need a free Power BI license (not Pro).

| Feature | Pro | Premium Capacity | Premium Per User | |---------|-----|-----------------|------------------| | License model | Per user | Capacity | Per user | | Content creation | Yes | Yes (with Pro license) | Yes | | Free viewers allowed | No | Yes | No | | Paginated reports | No | Yes | Yes | | AI features | No | Yes | Yes | | Dataset size limit | 1 GB | Up to 400 GB (P1) | Same as Premium | | Scheduled refreshes | 8/day | 48/day | 48/day | | Dedicated capacity | No | Yes | No | | XMLA endpoints | No | Yes | Yes | | Deployment pipelines | No | Yes | Yes | | Multi-Geo | No | Yes | No |

This table is exam-relevant: you may be asked which license supports a specific feature.

Understanding these differences is critical for the DP-900 exam and for real-world Power BI deployment decisions.

A multinational corporation with 50,000 employees wants to roll out Power BI dashboards for all staff. Only 500 employees are data analysts who create reports. The remaining 49,500 are consumers who only view dashboards. Using Pro licenses would cost $495,000/month (50,000 × $10). Instead, they purchase a Power BI Premium P3 capacity at approximately $20,000/month. Analysts still need Pro licenses (500 × $10 = $5,000/month), but consumers use free licenses. Total cost: $25,000/month — a 95% savings. The dedicated capacity ensures consistent performance even during peak usage. The IT team monitors the capacity using the Premium Capacity Metrics app to ensure it is not overburdened. Misconfiguration: If the capacity is too small (e.g., P1 for 50,000 users), performance degrades, and refreshes may fail. They must right-size the SKU.

A small marketing agency of 20 employees needs to create paginated reports for clients and use AI to analyze sentiment. All 20 users are both creators and consumers. Pro licenses would cost $200/month but do not support paginated reports or AI. They could purchase Premium Per User for $400/month (20 × $20), which gives them all Premium features. However, if they need to share reports with clients (external users) who do not have licenses, PPU does not allow that. They would need a Premium capacity (P1 at $4,995/month) which is too expensive. Alternative: they can ask clients to sign up for a free Power BI license and use PPU? No, PPU does not allow free viewers. So they either upgrade to capacity or require clients to have PPU. This scenario tests understanding of external sharing limitations.

An ISV wants to embed Power BI reports into their SaaS product for end customers. They need to use Power BI Embedded (which is essentially Premium capacity with an A SKU) or Premium capacity. They choose an A1 SKU (approximately $735/month) for development and scale up as needed. End users do not need any Power BI license — the ISV pays for the capacity. This is called 'app owns data' embedding. Misconfiguration: If they use a Pro license for embedding, each end user would need a Pro license, which is impractical. The exam may ask: 'Which licensing model supports embedding without per-user licensing?' Answer: Premium capacity or Power BI Embedded.