Power BI Service Masterclass: From Basics to Advanced - 2026

Create a Power BI service dashboard that presents high-level insights on a single page. Pin visuals from multiple data sets or reports, and preserve slicers and interactivity when pinning pages.

Create and share Power BI service apps that bundle dashboards, reports, and data sets. Learn how to prepare content in a workspace, configure the app, set audience, and publish.

Explore Power BI service report and semantic model settings, including export, sharing, and mobile layouts. Learn to subscribe, set alerts, view lineage, edit data models, and manage bookmarks.

A Power BI gateway bridges on-premises data to the service for secure cloud transfer, with standard gateway supporting multi-user access and personal gateway for Power BI only.

Learn to enable and schedule refresh in Power BI service, configure an on-premises gateway for on-premises sources, map data sources such as Excel and SQL Server, and monitor refresh history.

Create and manage user groups in Microsoft Entra (Azure Active Directory) and Microsoft 365 Admin Center to simplify access, sharing, and row-level security in Power BI service.

Understand workspace security in Power BI service through role based access control, detailing admin, member, contributor, and viewer roles and their permissions to manage, publish, and interact with content.

Implement static row-level security in Power BI by creating desktop roles to restrict data to predefined states, test with view as, then publish for viewer-only access.

Learn to implement dynamic row-level security in Power BI by building a user table, linking it to territory data, and using user principal name to filter data in the service.

Explore object level security (ols) in power bi, restricting whole tables or columns, and contrast it with row level security, with implementation via tabular editor and power bi service.

Manage users, credentials, and access for the Power BI service with Azure Active Directory, now Microsoft Entra, supported by authentication checks, MFA outcomes, and audit and sign-in logs.

Understand how multi-factor authentication protects Power BI service access with Microsoft Authenticator, enabling MFA via Azure Active Directory and secure login using QR code and notification approval.

Power BI service securely stores and encrypts data source credentials to refresh datasets without manual authentication, using OAuth 2.0, API keys, and service principals in Azure AD and Key Vault.

Explore all Power BI service sharing options, including direct share, data set sharing, embed in SharePoint and Teams, apps, subscriptions, publish to web, and exports.

Explain which licenses Power BI users need to view or share reports, including pro, premium, premium capacity, and fabric capacity, and how premium capacity lets end users view content.

Demonstrates direct share by sharing reports and dashboards with individuals or groups, and highlights license requirements for sharer and receiver (pro or premium, or premium per capacity).

Learn how to share semantic models in Power BI service, including licensing, premium workspace access, and permissions to let others build content on shared datasets.

Embed a Power BI report in SharePoint with the embed link, enabling interactive display and filters, noting free users view from premium workspace and others need pro or premium licenses.

Explore embedding in Teams from the Power BI service for reports and dashboards. Learn to generate links and share via mail, Teams, or PowerPoint, with pro or premium licenses.

Learn how to create and share Power BI apps across workspaces, assign licenses, manage audiences, and use user groups to distribute dashboards and reports.

Learn how to share Power BI reports via subscriptions, scheduling automatic emails, attaching PDFs, and managing access through pro and premium licenses for report recipients.

Publish to web shares reports publicly with no authentication, not secure for sensitive data; admins enable the option and you can generate, share, and eventually deactivate public embed codes.

Export reports to PDF, Excel, and PowerPoint for sharing, with consumption free but creation requiring a license in a premium workspace; embed live data in PowerPoint for interactivity.

Save pbix files to OneDrive or SharePoint to enable cloud sharing, then generate links for colleagues with view or edit permissions, noting that publishing requires a license.

Learn how to share an on premises gateway, assign John as a collaborator, manage connections and credentials, and configure schedule refresh including time, monitoring, and take over.

Master incremental refresh in Power BI by refreshing only new data with partitions, preceded by parameters and prerequisites like query folding, a date-time column, and import mode.

Discover how incremental refresh creates partitions in Power BI service, and verify them in SSMS by connecting to Analysis Services and inspecting the claims data partitions within the four-month window.

Data flows in Power BI provide cloud ETL with Power Query, storing data in Azure Data Lake Gen2. Reuse these flows across reports to reduce live connections and simplify refreshes.

Replace sql server sources with data flows across five reports by copying data flow codes into each table’s advanced editor, then publish and refresh from a single data flow.

Master manual deployment in power bi by managing development, test, and production environments, using parameters, gateways, and scheduled refresh to ensure stable, accurate end user reports.

Learn to automate deployment pipelines in Power BI service, moving content from development to test to production. Configure workspaces and apps, and use parameters to manage data sources across environments.

Learn to use PowerShell cmdlets to automate Power BI service tasks—refresh datasets, manage workspaces, and publish pbix files—by installing modules and authenticating without the GUI.

Create a new Power BI workspace using PowerShell cmdlets, authenticate to the Power BI service, and list existing workspaces before naming the new one.

Update a Power BI workspace with PowerShell by renaming it and verifying the change via the workspace ID, found in the Power BI service URL.

Discover how to see workspace accesses in Power BI service using PowerShell. Authenticate, run commands to view admin, member, contributor, and viewer roles, and list datasets, semantic models, and reports.

Learn how to retrieve all reports in a Power BI workspace using PowerShell, including logging in, fetching reports by workspace ID, and verifying report names.

Publish a Power BI report to a workspace in the Power BI service using PowerShell, without logging in, showing path, workspace ID, and naming, with automatic semantic model update.

Export a Power BI report from the service using PowerShell to download the pbix file. Identify the report ID and set the save path for reliable exports.

Learn to add a user to a Power BI workspace using PowerShell by authenticating to the Power BI service, providing the workspace ID, and assigning access rights.

Remove a user from a Power BI workspace using PowerShell by logging in, applying the remove command with the workspace ID and user name, and verifying removal, including batch deletions.

Learn to refresh a dataset or semantic model in Power BI service using PowerShell, including manual refresh, gateways, data source credentials, and API automation.

Compare development, test and production workspaces in Power BI to support fast iteration and controlled validation from development edits to production reports.

Identify the required tools and licenses for Power BI CI/CD, including Power BI Desktop, Power BI Service, GitHub Desktop, GitHub Web Portal, Microsoft 365, and SQL Server.

Track Power Query changes with git version control by using a feature branch, committing edits, and pushing to origin; merge via pull requests into development and main.

Publish a pbip to the development workspace and configure a three-stage deployment pipeline—development, test, and production—ensuring reports, datasets, and semantic models align across environments.

Power BI service integrates with Git repositories to enable version control and automatic syncing with GitHub. Use deployment pipelines to move changes from development to test and production.