Commands › Power BI

Add-PowerBIRow

Power BI MicrosoftPowerBIMgmt Add-*

Adds rows to the specified table in a Power BI dataset.

Quick start script

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

# 2. Run and inspect
Add-PowerBIRow -Dataset <Dataset> -DatasetId <Guid> -Rows <PSObject]> | Format-List

# 3. Export for evidence / drift tracking
Add-PowerBIRow | Export-Clixml .\PowerBIRow-$(Get-Date -Format yyyyMMdd).xml

Syntax — 2 parameter sets

Dataset (Default)

Add-PowerBIRow -Dataset <Dataset> -TableName <String>
 -Rows <System.Collections.Generic.List`1[System.Management.Automation.PSObject]> [-WorkspaceId <Guid>]
 [-Workspace <Workspace>] [<CommonParameters>]

DatasetId

Add-PowerBIRow -DatasetId <Guid> -TableName <String>
 -Rows <System.Collections.Generic.List`1[System.Management.Automation.PSObject]> [-WorkspaceId <Guid>]
 [-Workspace <Workspace>] [<CommonParameters>]

Parameters (6)

Parameter	Type	Required	What it controls
-Dataset	Dataset	yes	A dataset containing the table where rows are to be stored.
-DatasetId	Guid	yes	ID of the dataset containing the table where rows are to be stored.
-Rows	PSObject]	yes	An array of rows to be stored in the table.
-TableName	String	yes	Name of the table.
-Workspace	Workspace		Workspace containing the dataset and table for row insertion.
-WorkspaceId	Guid		ID of the workspace containing the dataset and table for row insertion.

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