Commands › Power BI

Set-PowerBITable

Power BI MicrosoftPowerBIMgmt Set-*

Updates the metadata and schema for the specified Power BI table.

Quick start script

# Set-PowerBITable — quick start (serv365.ai)
# 1. Connect (app-only shown; interactive: omit the certificate parameters)
Connect-PowerBIServiceAccount -ServicePrincipal -CertificateThumbprint $thumb -ApplicationId $appId -Tenant $tenantId

# 2. Capture the current state first — you cannot roll back what you never recorded
$before = Get-PowerBITable
$before | Format-List

# 3. Make the change
Set-PowerBITable -Dataset <Dataset> -DatasetId <Guid> -Table <Table>

# 4. Verify and diff
$after = Get-PowerBITable
Compare-Object ($before | Out-String) ($after | Out-String)

Syntax — 2 parameter sets

DatasetId (Default)

Set-PowerBITable -Table <Table> -DatasetId <Guid> [-WorkspaceId <Guid>] [-Workspace <Workspace>]
 [<CommonParameters>]

Dataset

Set-PowerBITable -Table <Table> -Dataset <Dataset> [-WorkspaceId <Guid>] [-Workspace <Workspace>]
 [<CommonParameters>]

Parameters (5)

Parameter	Type	Required	What it controls
-Dataset	Dataset	yes	A dataset where tables are stored.
-DatasetId	Guid	yes	ID of the dataset where tables are to be stored.
-Table	Table	yes	Table to update the schema.
-Workspace	Workspace		Workspace to filter the place where table resides.
-WorkspaceId	Guid		ID of the workspace to filter the place where table resides.

Reference facts derived from Microsoft documentation, © Microsoft, licensed MIT; restructured with original guidance by serv365.ai.