Sunday, December 03, 2023

Lesson 3 – Introduction to Power BI Service


Power BI Desktop is used to create reports, while Power BI Service is used to publish, share, and collaborate on those reports in the cloud. It enables users to access dashboards from anywhere, schedule data refreshes, manage workspaces, and securely share insights across teams.
As part of the Microsoft Fabric ecosystem, Power BI Service also integrates with OneLake and other Fabric experiences, making it a central platform for modern business intelligence and collaboration.

What is Power BI Service?

Power BI Service (also known as Power BI Online) is Microsoft's cloud-based Software as a Service (SaaS) platform for sharing, collaborating, and managing Power BI content. After creating reports in Power BI Desktop, users publish them to Power BI Service, where they can securely share reports, dashboards, semantic models, and apps with others.

Power BI Service also enables features such as scheduled data refresh, collaboration through workspaces, row-level security (RLS), subscriptions, deployment pipelines, and integration with Microsoft Fabric.

Whether you're a report creator or a report consumer, the type of Power BI license assigned to you determines the features you can access.

Power BI Licensing

Power BI offers different licensing options depending on how you create, share, and consume content.

Free License

Users can sign in to Power BI Service (https://app.powerbi.com/) with a free Microsoft account or an organizational account.

With a Free license, users can:

  • Create reports and dashboards in My Workspace
  • Connect to supported data sources
  • Publish reports to their personal workspace
  • View content that is shared from workspaces running on Fabric Capacity (formerly Premium Capacity), provided they have the necessary permissions

However, Free users cannot share reports or collaborate in shared workspaces unless they are assigned a Pro license.

You can check your current license by selecting your Profile icon → View account in the Power BI Service.

You need to have either a Power BI Pro or Premium Per User (PPU) License if you want to publish and share reports within or outside your organisation.

Power BI Pro License

Power BI Pro is an individual user license designed for report authors and collaborators. It allows users to create, publish, share, and collaborate on reports, dashboards, semantic models, and apps within Power BI Service.

With a Pro license, users can:

  • Create and publish Power BI reports.
  • Share reports and dashboards with other users who have a Pro license.
  • Collaborate in shared workspaces.
  • Consume content hosted in Microsoft Fabric Capacity (or existing Premium Capacity workspaces) without requiring every consumer to have a Pro license, provided appropriate permissions are granted.

Premium Per User (PPU) License

Premium Per User (PPU) is an individual license that includes all the capabilities of Power BI Pro, along with advanced Premium features available on a per-user basis.

In addition to Pro features, PPU provides access to capabilities such as:

  • AI-powered features
  • Larger semantic model sizes
  • Paginated Reports
  • Advanced deployment pipelines
  • Enhanced performance and scalability
  • Other Premium capabilities without requiring dedicated capacity

Content published in a PPU workspace can only be accessed by users who also have a PPU license, unless it is moved to a workspace running on Microsoft Fabric Capacity.

Microsoft Fabric Capacity (formerly Power BI Premium Capacity)

Microsoft Fabric Capacity provides dedicated compute resources for organizations and supports workloads across Microsoft Fabric, including Power BI.

Workspaces assigned to Fabric Capacity enable organizations to:

  • Share Power BI content with users who have Free licenses (subject to permissions).
  • Run larger semantic models and enterprise-scale analytics.
  • Support advanced Fabric workloads such as Lakehouses, Warehouses, Data Engineering, Data Science, Real-Time Intelligence, and Power BI.
  • Improve performance, scalability, and governance for enterprise BI solutions.

Note: Microsoft now recommends Microsoft Fabric Capacity (F SKUs) for new deployments. Existing Power BI Premium Capacity (P SKUs) customers continue to be supported, but Microsoft is encouraging organizations to transition to Fabric Capacity over time.

Power BI Pricing

Microsoft periodically updates Power BI licensing and pricing. Rather than listing fixed prices, it's recommended to check the official Microsoft pricing page for the most up-to-date information on:

  • Power BI Free
  • Power BI Pro
  • Power BI Premium Per User (PPU)
  • Microsoft Fabric Capacity

Note: Pricing may vary by region and is subject to change. Refer to the official Microsoft Power BI Pricing page link for the latest information.

Once report authors create reports in Power BI Desktop or Power BI Service, they can publish them to Power BI Service for collaboration, sharing, and centralized management. Power BI Service provides several components that help organizations securely organize, distribute, and manage their business intelligence content:

Components of Power BI Service:

Workspaces

Workspaces are collaborative environments where users can create, manage, and share Power BI and Microsoft Fabric content. A workspace can contain reports, dashboards, semantic models, dataflows, apps, and other Microsoft Fabric items such as Lakehouses and Warehouses.

There are two types of workspaces in Power BI Service:

My Workspace – A personal workspace where users can create and manage their own content. By default, only the workspace owner has access to this content unless it is explicitly shared.

Shared Workspaces – Collaborative workspaces where multiple users can create, edit, and manage content together. Access is controlled through workspace roles such as Admin, Member, Contributor, and Viewer.

Apps

Apps provide a simple and secure way to distribute Power BI content to end users. Report authors can package reports, dashboards, semantic models, and other related content into a single app that users can easily install and access.

Apps are designed primarily for content consumption. End users can interact with reports and dashboards based on their permissions but cannot modify the published content.

Dataflows

Dataflows enable organizations to ingest, clean, and transform data using Power Query in the cloud. They help establish a single source of truth by centralizing data preparation so that multiple reports and semantic models can reuse the same transformed data.

Microsoft Fabric also introduces Dataflows Gen2, which provide enhanced performance, improved scalability, and deeper integration with Microsoft Fabric workloads such as Lakehouses and Data Warehouses.

Semantic Models (formerly Datasets)

A Semantic Model is the analytical layer that stores data, relationships, measures, hierarchies, and business logic used for reporting. Semantic models are created by importing data or connecting to supported data sources and serve as the foundation for Power BI reports.

Multiple reports can connect to and reuse a single semantic model, promoting consistency and reducing data duplication across an organization.

Note: Microsoft has renamed Datasets to Semantic Models. Although the functionality remains the same, "Semantic Model" is now the preferred terminology throughout Power BI and Microsoft Fabric.

Reports

A Power BI Report is a collection of one or more pages containing interactive visualizations such as charts, tables, maps, KPIs, and slicers. All visuals within a report are based on a single semantic model.

Reports support interactive features such as filtering, drill-down, drill-through, bookmarks, tooltips, and cross-filtering. Reports can be created using both Power BI Desktop and Power BI Service.

Dashboards

A Dashboard is a single-page canvas that displays important business metrics by combining visualizations pinned from one or more reports. Dashboards provide a consolidated view of key information, making it easier for users to monitor business performance at a glance.

Dashboards can only be created and managed in Power BI Service and support features such as real-time monitoring, alerts, and quick navigation to the underlying reports.

Conclusion

Power BI Service is the cloud platform that enables users to securely publish, share, collaborate, and manage Power BI content across an organization. While Power BI Desktop is used to build reports, Power BI Service provides the environment where reports, dashboards, semantic models, apps, and other Microsoft Fabric assets can be shared and consumed by end users.

With features such as workspaces, apps, scheduled refresh, row-level security (RLS), subscriptions, and seamless integration with Microsoft Fabric, Power BI Service supports collaboration at both individual and enterprise levels. Understanding the different licensing options and the core components of Power BI Service is essential for effectively deploying and managing business intelligence solutions.

As organizations continue to adopt Microsoft Fabric, Power BI Service plays an increasingly important role by bringing together reporting, collaboration, governance, and data management into a unified cloud platform. Mastering Power BI Service is therefore an essential step for anyone looking to build, share, and maintain modern, enterprise-grade analytics solutions.

Useful Information

No comments:

Post a Comment