Get-PowerBITable

Reference

Module:: MicrosoftPowerBIMgmt.Data

Returns a list of Power BI tables.

Syntax

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

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

Description

Retrieves a list of Power BI tables in the dataset that match the specified search criteria. Before you run this command, make sure you log in using Login-PowerBIServiceAccount.

Examples

Example 1

PS C:\> Get-PowerBITable -DatasetId eed49d27-8e3c-424d-9342-c6b3ca6db64d

Returns a list of all Power BI tables in dataset eed49d27-8e3c-424d-9342-c6b3ca6db64d

Example 2

PS C:\> Get-PowerBIDataset | ? AddRowsApiEnabled -eq $true | Get-PowerBITable

Returns a list of all Power BI tables in datasets which supports AddRowApi.

Parameters

-Dataset

The dataset where the tables are stored.

Type:	Dataset
Position:	Named
Default value:	None
Required:	True
Accept pipeline input:	True
Accept wildcard characters:	False

-DatasetId

ID of the dataset where the tables are stored.

Type:	Guid
Position:	Named
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False

-First

First (top) list of results.

Type:	Int32
Aliases:	Top
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-Name

Name of the table to return if one exists with that name. Case insensitive search.

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-Scope

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 the default.

Type:	PowerBIUserScope
Accepted values:	Individual, Organization
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-Skip

Skips the first set of results.

Type:	Int32
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-Workspace

Workspace to filter results to, tables only belonging to that workspace are shown.

Type:	Workspace
Aliases:	Group
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-WorkspaceId

ID of the workspace to filter results to, tables only belonging to that workspace are shown.

Type:	Guid
Aliases:	GroupId
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

Inputs

Microsoft.PowerBI.Common.Api.Datasets.Dataset

Outputs

System.Object