Commands › Power BI
Remove-PowerBIRow
Removes rows from a Power BI table.
Quick start script
# Remove-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. Capture the current state first — you cannot roll back what you never recorded
$before = Get-PowerBIRow
$before | Format-List
# 3. Make the change
Remove-PowerBIRow -Dataset <Dataset> -DatasetId <Guid> -TableName <String>
# 4. Verify and diff
$after = Get-PowerBIRow
Compare-Object ($before | Out-String) ($after | Out-String)Syntax — 2 parameter sets
Dataset (Default)
Remove-PowerBIRow -Dataset <Dataset> -TableName <String> [-WorkspaceId <Guid>] [-Workspace <Workspace>]
[<CommonParameters>]DatasetId
Remove-PowerBIRow -DatasetId <Guid> -TableName <String> [-WorkspaceId <Guid>] [-Workspace <Workspace>]
[<CommonParameters>]Parameters (5)
| Parameter | Type | Required | What it controls |
|---|---|---|---|
| -Dataset | Dataset | yes | A dataset containing the table where rows are to be removed. |
| -DatasetId | Guid | yes | ID of the dataset containing the table where rows are to be removed. |
| -TableName | String | yes | Name of the table. |
| -Workspace | Workspace | Workspace containing the dataset and table for row removal. | |
| -WorkspaceId | Guid | ID of the workspace containing the dataset and table for row removal. |
Reference facts derived from Microsoft documentation, © Microsoft, licensed MIT; restructured with original guidance by serv365.ai.