PowerShell for Microsoft Fabric
Automate Microsoft Fabric and Power BI administration: 214 commands across 38 item types.
Install-Module FabricTools
214 of 214
Item type
Verb
Core7
Connect-FabricAccountConnects to the Fabric WebAPI.Get-FabricAPIclusterURIRetrieves the cluster URI for the tenant.Get-FabricAuthTokenRetrieves the Fabric API authentication token.Get-FabricConnectionRetrieves Fabric connections.Get-FabricDebugInfoShows internal debug information about the current Azure & Fabric sessions & Fabric config.Invoke-FabricRestMethodSends an HTTP request to a Fabric or Power BI API endpoint and retrieve the response.Get-FabricUsageMetricsQueryRetrieves usage metrics for a specific dataset.
Capacity10
Get-FabricCapacitiesThis function retrieves all resources of type "Microsoft.Fabric/capacities" from all resource groups in a given subscription or all subscriptions if no subscription ID is provided.Get-FabricCapacityRetrieves capacity details from a specified Microsoft Fabric workspace.Update-FabricCapacityCreates or updates a Microsoft Fabric capacity.Resume-FabricCapacityResumes a capacity.Suspend-FabricCapacitySuspends a capacity.Get-FabricCapacityRefreshablesReturns a list of refreshables for all capacities that the user has access to.Get-FabricCapacitySkusRetrieves the fabric capacity information.Get-FabricCapacityStateRetrieves the state of a specific capacity.Get-FabricCapacityTenantOverridesRetrieves the tenant overrides for all capacities.Get-FabricCapacityWorkloadRetrieves the workloads for a specific capacity.
Config1
Copy Job6
Get-FabricCopyJobRetrieves CopyJob details from a specified Microsoft Fabric workspace.New-FabricCopyJobCreates a new copy job in a specified Microsoft Fabric workspace.Update-FabricCopyJobUpdates an existing Copy Job in a specified Microsoft Fabric workspace.Remove-FabricCopyJobDeletes a Copy Job from a specified Microsoft Fabric workspace.Get-FabricCopyJobDefinitionRetrieves the definition of a Copy Job from a specific workspace in Microsoft Fabric.Update-FabricCopyJobDefinitionUpdates the definition of a Copy Job in a Microsoft Fabric workspace.
Dashboard1
Data Pipeline4
Get-FabricDataPipelineRetrieves data pipelines from a specified Microsoft Fabric workspace.New-FabricDataPipelineCreates a new DataPipeline in a specified Microsoft Fabric workspace.Update-FabricDataPipelineUpdates an existing DataPipeline in a specified Microsoft Fabric workspace.Remove-FabricDataPipelineRemoves a DataPipeline from a specified Microsoft Fabric workspace.
Datamart1
Dataset3
Deployment Pipeline10
Get-FabricDeploymentPipelineRetrieves deployment pipeline(s) from Microsoft Fabric.New-FabricDeploymentPipelineCreates a new deployment pipeline.Remove-FabricDeploymentPipelineDeletes a specified deployment pipeline.Get-FabricDeploymentPipelineOperationRetrieves details of a specific deployment pipeline operation.Get-FabricDeploymentPipelineRoleAssignmentsReturns a list of deployment pipeline role assignments.Get-FabricDeploymentPipelineStageRetrieves details of deployment pipeline stages.Start-FabricDeploymentPipelineStageDeploys items from one stage to another in a deployment pipeline.Get-FabricDeploymentPipelineStageItemRetrieves the supported items from the workspace assigned to a specific stage of a deployment pipeline.Remove-FabricWorkspaceFromStageRemoves a workspace from a deployment pipeline stage.Add-FabricWorkspaceToStageAssigns a workspace to a deployment pipeline stage.
Domain11
Get-FabricDomainRetrieves domain information from Microsoft Fabric, optionally filtering by domain ID, domain name, or only non-empty domains.New-FabricDomainCreates a new Fabric domain.Update-FabricDomainUpdates a Fabric domain by its ID.Remove-FabricDomainDeletes a Fabric domain by its ID.Get-FabricDomainWorkspaceRetrieves the workspaces associated with a specific domain in Microsoft Fabric.Remove-FabricDomainWorkspaceAssignmentUnassign workspaces from a specified Fabric domain.Add-FabricDomainWorkspaceAssignmentByCapacityAssigns workspaces to a Fabric domain based on specified capacities.Add-FabricDomainWorkspaceAssignmentByIdAssigns workspaces to a specified domain in Microsoft Fabric by their IDs.Add-FabricDomainWorkspaceAssignmentByPrincipalAssigns workspaces to a domain based on principal IDs in Microsoft Fabric.Remove-FabricDomainWorkspaceRoleAssignmentBulk unassign roles to principals for workspaces in a Fabric domain.Add-FabricDomainWorkspaceRoleAssignmentBulk assigns roles to principals for workspaces in a Fabric domain.
Environment13
Get-FabricEnvironmentRetrieves an environment or a list of environments from a specified workspace in Microsoft Fabric.New-FabricEnvironmentCreates a new environment in a specified workspace.Update-FabricEnvironmentUpdates the properties of a Fabric Environment.Remove-FabricEnvironmentDeletes an environment from a specified workspace in Microsoft Fabric.Publish-FabricEnvironmentPublishes a staging environment in a specified Microsoft Fabric workspace.Get-FabricEnvironmentLibraryRetrieves the list of libraries associated with a specific environment in a Microsoft Fabric workspace.Stop-FabricEnvironmentPublishCancels the publish operation for a specified environment in Microsoft Fabric.Get-FabricEnvironmentSparkComputeRetrieves the Spark compute details for a specific environment in a Microsoft Fabric workspace.Get-FabricEnvironmentStagingLibraryRetrieves the staging library details for a specific environment in a Microsoft Fabric workspace.Remove-FabricEnvironmentStagingLibraryDeletes a specified library from the staging environment in a Microsoft Fabric workspace.Import-FabricEnvironmentStagingLibraryUploads a library to the staging environment in a Microsoft Fabric workspace.Get-FabricEnvironmentStagingSparkComputeRetrieves staging Spark compute details for a specific environment in a Microsoft Fabric workspace.Update-FabricEnvironmentStagingSparkComputeUpdates the Spark compute configuration in the staging environment for a given workspace.
Eventhouse6
Get-FabricEventhouseRetrieves Fabric EventhousesNew-FabricEventhouseCreates a new Eventhouse in a specified Microsoft Fabric workspace.Update-FabricEventhouseUpdates an existing Eventhouse in a specified Microsoft Fabric workspace.Remove-FabricEventhouseRemoves an Eventhouse from a specified Microsoft Fabric workspace.Get-FabricEventhouseDefinitionRetrieves the definition of an Eventhouse from a specified Microsoft Fabric workspace.Update-FabricEventhouseDefinitionUpdates the definition of an existing Eventhouse in a specified Microsoft Fabric workspace.
Eventstream6
Get-FabricEventstreamRetrieves an Eventstream or a list of Eventstreams from a specified workspace in Microsoft Fabric.New-FabricEventstreamCreates a new Eventstream in a specified Microsoft Fabric workspace.Update-FabricEventstreamUpdates the properties of a Fabric Eventstream.Remove-FabricEventstreamDeletes an Eventstream from a specified workspace in Microsoft Fabric.Get-FabricEventstreamDefinitionRetrieves the definition of a Eventstream from a specific workspace in Microsoft Fabric.Update-FabricEventstreamDefinitionUpdates the definition of a Eventstream in a Microsoft Fabric workspace.
External Data Share2
Git9
Connect-FabricGitConnects a Fabric workspace to a Git repository and branch.Disconnect-FabricGitDisconnects a Fabric workspace from its Git repository.Invoke-FabricGitCommitCommits changes from a Fabric workspace to the connected Git branch.Get-FabricGitConnectionGets the Git connection details of a Fabric workspace.Initialize-FabricGitConnectionInitializes the Git connection of a Fabric workspace.Get-FabricGitCredentialGets the Git credentials configuration of the current user for a Fabric workspace.Update-FabricGitCredentialUpdates the Git credentials configuration of the current user for a Fabric workspace.Get-FabricGitStatusGets the Git status of the items in a Fabric workspace.Invoke-FabricGitUpdateUpdates a Fabric workspace with the latest commits from the connected Git branch.
Item4
Get-FabricItemRetrieves fabric items from a workspace.Remove-FabricItemRemoves selected items from a Fabric workspace.Export-FabricItemExports items from a Fabric workspace. Either all items in a workspace or a specific item.Import-FabricItemImports items using the Power BI Project format (PBIP) into a Fabric workspace from a specified file system source.
KQL Dashboard6
Get-FabricKQLDashboardRetrieves an KQLDashboard or a list of KQLDashboards from a specified workspace in Microsoft Fabric.New-FabricKQLDashboardCreates a new KQLDashboard in a specified Microsoft Fabric workspace.Update-FabricKQLDashboardUpdates the properties of a Fabric KQLDashboard.Remove-FabricKQLDashboardDeletes an KQLDashboard from a specified workspace in Microsoft Fabric.Get-FabricKQLDashboardDefinitionRetrieves the definition of a KQLDashboard from a specific workspace in Microsoft Fabric.Update-FabricKQLDashboardDefinitionUpdates the definition of a KQLDashboard in a Microsoft Fabric workspace.
KQL Database6
Get-FabricKQLDatabaseRetrieves an KQLDatabase or a list of KQLDatabases from a specified workspace in Microsoft Fabric.New-FabricKQLDatabaseCreates a new KQLDatabase in a specified Microsoft Fabric workspace.Update-FabricKQLDatabaseUpdates the properties of a Fabric KQLDatabase.Remove-FabricKQLDatabaseDeletes an KQLDatabase from a specified workspace in Microsoft Fabric.Get-FabricKQLDatabaseDefinitionRetrieves the definition of a KQLDatabase from a specific workspace in Microsoft Fabric.Update-FabricKQLDatabaseDefinitionUpdates the definition of a KQLDatabase in a Microsoft Fabric workspace.
KQL Queryset7
Invoke-FabricKQLCommandExecutes a KQL command in a Kusto Database.Get-FabricKQLQuerysetRetrieves an KQLQueryset or a list of KQLQuerysets from a specified workspace in Microsoft Fabric.New-FabricKQLQuerysetCreates a new KQLQueryset in a specified Microsoft Fabric workspace.Update-FabricKQLQuerysetUpdates the properties of a Fabric KQLQueryset.Remove-FabricKQLQuerysetDeletes an KQLQueryset from a specified workspace in Microsoft Fabric.Get-FabricKQLQuerysetDefinitionRetrieves the definition of a KQLQueryset from a specific workspace in Microsoft Fabric.Update-FabricKQLQuerysetDefinitionUpdates the definition of a KQLQueryset in a Microsoft Fabric workspace.
Lakehouse7
Get-FabricLakehouseRetrieves an Lakehouse or a list of Lakehouses from a specified workspace in Microsoft Fabric.New-FabricLakehouseCreates a new Lakehouse in a specified Microsoft Fabric workspace.Update-FabricLakehouseUpdates the properties of a Fabric Lakehouse.Remove-FabricLakehouseDeletes an Lakehouse from a specified workspace in Microsoft Fabric.Get-FabricLakehouseTableRetrieves tables from a specified Lakehouse in a Fabric workspace.Write-FabricLakehouseTableDataLoads data into a specified table in a Lakehouse within a Fabric workspace.Start-FabricLakehouseTableMaintenanceInitiates a table maintenance job for a specified Lakehouse in a Fabric workspace.
Mirrored Database10
Get-FabricMirroredDatabaseRetrieves an MirroredDatabase or a list of MirroredDatabases from a specified workspace in Microsoft Fabric.New-FabricMirroredDatabaseCreates a new MirroredDatabase in a specified Microsoft Fabric workspace.Update-FabricMirroredDatabaseUpdates the properties of a Fabric MirroredDatabase.Remove-FabricMirroredDatabaseDeletes an MirroredDatabase from a specified workspace in Microsoft Fabric.Get-FabricMirroredDatabaseDefinitionRetrieves the definition of a MirroredDatabase from a specific workspace in Microsoft Fabric.Update-FabricMirroredDatabaseDefinitionUpdates the definition of a MirroredDatabase in a Microsoft Fabric workspace.Start-FabricMirroredDatabaseMirroringStarts the mirroring of a specified mirrored database in a given workspace.Stop-FabricMirroredDatabaseMirroringStops the mirroring of a specified mirrored database in a given workspace.Get-FabricMirroredDatabaseStatusRetrieves the status of a mirrored database in a specified workspace.Get-FabricMirroredDatabaseTableStatusRetrieves the status of tables in a mirrored database.
Mirrored Warehouse1
ML Experiment4
Get-FabricMLExperimentRetrieves ML Experiment details from a specified Microsoft Fabric workspace.New-FabricMLExperimentCreates a new ML Experiment in a specified Microsoft Fabric workspace.Update-FabricMLExperimentUpdates an existing ML Experiment in a specified Microsoft Fabric workspace.Remove-FabricMLExperimentRemoves an ML Experiment from a specified Microsoft Fabric workspace.
ML Model4
Get-FabricMLModelRetrieves ML Model details from a specified Microsoft Fabric workspace.New-FabricMLModelCreates a new ML Model in a specified Microsoft Fabric workspace.Update-FabricMLModelUpdates an existing ML Model in a specified Microsoft Fabric workspace.Remove-FabricMLModelRemoves an ML Model from a specified Microsoft Fabric workspace.
Notebook7
Get-FabricNotebookRetrieves an Notebook or a list of Notebooks from a specified workspace in Microsoft Fabric.New-FabricNotebookCreates a new notebook in a specified Microsoft Fabric workspace.Update-FabricNotebookUpdates the properties of a Fabric Notebook.Remove-FabricNotebookDeletes an Notebook from a specified workspace in Microsoft Fabric.Start-FabricNotebookStarts a notebook in Microsoft Fabric.Get-FabricNotebookDefinitionRetrieves the definition of a notebook from a specific workspace in Microsoft Fabric.Update-FabricNotebookDefinitionUpdates the definition of a notebook in a Microsoft Fabric workspace.
Paginated Reports2
Reflex6
Get-FabricReflexRetrieves Reflex details from a specified Microsoft Fabric workspace.New-FabricReflexCreates a new Reflex in a specified Microsoft Fabric workspace.Update-FabricReflexUpdates an existing Reflex in a specified Microsoft Fabric workspace.Remove-FabricReflexRemoves an Reflex from a specified Microsoft Fabric workspace.Get-FabricReflexDefinitionRetrieves the definition of an Reflex from a specified Microsoft Fabric workspace.Update-FabricReflexDefinitionUpdates the definition of an existing Reflex in a specified Microsoft Fabric workspace.
Report6
Get-FabricReportRetrieves Report details from a specified Microsoft Fabric workspace.New-FabricReportCreates a new Report in a specified Microsoft Fabric workspace.Update-FabricReportUpdates an existing Report in a specified Microsoft Fabric workspace.Remove-FabricReportRemoves an Report from a specified Microsoft Fabric workspace.Get-FabricReportDefinitionRetrieves the definition of an Report from a specified Microsoft Fabric workspace.Update-FabricReportDefinitionUpdates the definition of an existing Report in a specified Microsoft Fabric workspace.
Semantic Model6
Get-FabricSemanticModelRetrieves SemanticModel details from a specified Microsoft Fabric workspace.New-FabricSemanticModelCreates a new SemanticModel in a specified Microsoft Fabric workspace.Update-FabricSemanticModelUpdates an existing SemanticModel in a specified Microsoft Fabric workspace.Remove-FabricSemanticModelRemoves an SemanticModel from a specified Microsoft Fabric workspace.Get-FabricSemanticModelDefinitionRetrieves the definition of an SemanticModel from a specified Microsoft Fabric workspace.Update-FabricSemanticModelDefinitionUpdates the definition of an existing SemanticModel in a specified Microsoft Fabric workspace.
Spark6
Get-FabricSparkCustomPoolRetrieves Spark custom pools from a specified workspace.New-FabricSparkCustomPoolCreates a new Spark custom pool in a specified Microsoft Fabric workspace.Update-FabricSparkCustomPoolUpdates an existing Spark custom pool in a specified Microsoft Fabric workspace.Remove-FabricSparkCustomPoolRemoves a Spark custom pool from a specified Microsoft Fabric workspace.Get-FabricSparkSettingsRetrieves Spark settings from a specified Microsoft Fabric workspace.Update-FabricSparkSettingsUpdates Spark settings in a specified Microsoft Fabric workspace.
Spark Job Definition7
Get-FabricSparkJobDefinitionRetrieves Spark Job Definition details from a specified Microsoft Fabric workspace.New-FabricSparkJobDefinitionCreates a new SparkJobDefinition in a specified Microsoft Fabric workspace.Update-FabricSparkJobDefinitionUpdates an existing SparkJobDefinition in a specified Microsoft Fabric workspace.Remove-FabricSparkJobDefinitionRemoves an SparkJobDefinition from a specified Microsoft Fabric workspace.Get-FabricSparkJobDefinitionDefinitionRetrieves the definition of an SparkJobDefinition from a specified Microsoft Fabric workspace.Update-FabricSparkJobDefinitionDefinitionUpdates the definition of an existing SparkJobDefinition in a specified Microsoft Fabric workspace.Start-FabricSparkJobDefinitionOnDemandStarts a Fabric Spark Job Definition on demand.
SQL Database3
SQL Endpoints2
Tenant6
Get-FabricCapacityTenantSettingOverridesRetrieves tenant setting overrides for a specific capacity or all capacities in the Fabric tenant.Update-FabricCapacityTenantSettingOverridesUpdates tenant setting overrides for a specified capacity ID.Revoke-FabricCapacityTenantSettingOverridesRemoves a tenant setting override from a specific capacity in the Fabric tenant.Get-FabricDomainTenantSettingOverridesRetrieves tenant setting overrides for a specific domain or all capacities in the Fabric tenant.Get-FabricTenantSettingRetrieves tenant settings from the Fabric environment.Get-FabricWorkspaceTenantSettingOverridesRetrieves tenant setting overrides for all workspaces in the Fabric tenant.
Users1
Utils4
Get-FabricLongRunningOperationMonitors the status of a long-running operation in Microsoft Fabric.Get-FabricLongRunningOperationResultRetrieves the result of a completed long-running operation from the Microsoft Fabric API.Convert-FromBase64Decodes a Base64-encoded string into its original text representation.Convert-ToBase64Encodes the content of a file into a Base64-encoded string.
Warehouse4
Get-FabricWarehouseRetrieves warehouse details from a specified Microsoft Fabric workspace.New-FabricWarehouseCreates a new warehouse in a specified Microsoft Fabric workspace.Update-FabricWarehouseUpdates an existing warehouse in a specified Microsoft Fabric workspace.Remove-FabricWarehouseRemoves a warehouse from a specified Microsoft Fabric workspace.
Workspace15
Get-FabricWorkspaceRetrieves details of a Microsoft Fabric workspace by its ID or name.New-FabricWorkspaceCreates a new Fabric workspace with the specified display name.Update-FabricWorkspaceUpdates the properties of a Fabric workspace.Remove-FabricWorkspaceDeletes an existing Fabric workspace by its workspace ID or name.Remove-FabricWorkspaceCapacityUnassigns a Fabric workspace from its capacity.Add-FabricWorkspaceCapacityAssigns a Fabric workspace to a specified capacity.Remove-FabricWorkspaceIdentityDeprovisions the Managed Identity for a specified Fabric workspace.Add-FabricWorkspaceIdentityProvisions an identity for a Fabric workspace.Get-FabricWorkspaceRoleAssignmentRetrieves role assignments for a specified Fabric workspace.Update-FabricWorkspaceRoleAssignmentUpdates the role assignment for a specific principal in a Fabric workspace.Remove-FabricWorkspaceRoleAssignmentRemoves a role assignment from a Fabric workspace.Add-FabricWorkspaceRoleAssignmentAssigns a role to a principal for a specified Fabric workspace.Get-FabricWorkspaceUsageMetricsDataRetrieves workspace usage metrics data.New-FabricWorkspaceUsageMetricsReportRetrieves the workspace usage metrics dataset ID.Get-FabricWorkspaceUserRetrieves the user(s) of a workspace.