Skip to content

PowerBIHelper

Description

PowerShell module for managing and automating tasks in the Power BI service.

GitLab Repository

Features

  • Create, rename, and remove Power BI workspaces.
  • Manage associated Active Directory security groups for workspaces.
  • Authenticate using Azure Service Principals with permissions managed in PasswordState.
  • Automate CRM-specific workspace configurations.

Functions

Workspace Management

  • New-PBIWorkspace: Creates a new workspace in the Power BI service with appropriate permissions and AD group associations.
  • Remove-PBIWorkspace: Removes specified workspaces and their associated AD security groups.
  • Rename-PBIWorkspace: Renames specified workspaces and updates associated AD security groups.

Connection

  • Connect-DGPowerBI: Authenticates with the Power BI service using a service principal.

Dependencies

  • MicrosoftPowerBIMgmt: Required for managing Power BI service operations.
  • AzureAD: Required for managing Azure Active Directory.
  • PasswordStateHelper: Required for securely managing credentials.

Roadmap

  • Add support for advanced workspace configurations.
  • Enhance reporting capabilities for workspace management.
  • Integrate with additional modules for broader automation workflows.

Changelog

  • 23/09/2019: Initial release of the module.
  • 01/04/2025: Updated functions and documentation.