Commands › Power BI

Get-PowerBITable

Power BI MicrosoftPowerBIMgmt Get-*

Returns a list of Power BI tables.

Quick start script

# Get-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. Run and inspect
Get-PowerBITable -Dataset <Dataset> -DatasetId <Guid> | Format-List

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

Syntax — 2 parameter sets

DatasetId (Default)

Get-PowerBITable -DatasetId <Guid> [-Name <String>] [-Scope <PowerBIUserScope>] [-First <Int32>]
 [-Skip <Int32>] [-WorkspaceId <Guid>] [-Workspace <Workspace>] [<CommonParameters>]

Dataset

Get-PowerBITable -Dataset <Dataset> [-Name <String>] [-Scope <PowerBIUserScope>] [-First <Int32>]
 [-Skip <Int32>] [-WorkspaceId <Guid>] [-Workspace <Workspace>] [<CommonParameters>]

Parameters (8)

Parameter	Type	Required	What it controls
-Dataset	Dataset	yes	The dataset where the tables are stored.
-DatasetId	Guid	yes	ID of the dataset where the tables are stored.
-First	Int32		First (top) list of results.
-Name	String		Name of the table to return if one exists with that name. Case insensitive search.
-Scope	PowerBIUserScope		Indicates scope of the call. Individual returns only tables under datasets assigned to the caller; Organization returns tables under any dataset within a tenant (must be an administrator to initiate). Individual is...
-Skip	Int32		Skips the first set of results.
-Workspace	Workspace		Workspace to filter results to, tables only belonging to that workspace are shown.
-WorkspaceId	Guid		ID of the workspace to filter results to, tables only belonging to that workspace are shown.

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