Get-PowerBITable

NAME Get-PowerBITable



SYNOPSIS

Returns a list of Power BI tables.





SYNTAX

Get-PowerBITable -Dataset <Dataset> [-First <Int32>] [-Name <String>] [-Scope {Individual | Organization}] [-Skip

<Int32>] [-Workspace <Workspace>] [-WorkspaceId <Guid>] [<CommonParameters>]



Get-PowerBITable -DatasetId <Guid> [-First <Int32>] [-Name <String>] [-Scope {Individual | Organization}] [-Skip

<Int32>] [-Workspace <Workspace>] [-WorkspaceId <Guid>] [<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.





PARAMETERS

-Dataset <Dataset>

The dataset where the tables are stored.



Required? true

Position? named

Default value None

Accept pipeline input? True (ByValue)

Accept wildcard characters? false



-DatasetId <Guid>

ID of the dataset where the tables are stored.



Required? true

Position? named

Default value None

Accept pipeline input? False

Accept wildcard characters? false



-First <Int32>

First (top) list of results.



Required? false

Position? named

Default value None

Accept pipeline input? False

Accept wildcard characters? false



-Name <String>

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



Required? false

Position? named

Default value None

Accept pipeline input? False

Accept wildcard characters? false



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



Required? false

Position? named

Default value None

Accept pipeline input? False

Accept wildcard characters? false



-Skip <Int32>

Skips the first set of results.



Required? false

Position? named

Default value None

Accept pipeline input? False

Accept wildcard characters? false



-Workspace <Workspace>

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



Required? false

Position? named

Default value None

Accept pipeline input? False

Accept wildcard characters? false



-WorkspaceId <Guid>

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



Required? false

Position? named

Default value None

Accept pipeline input? False

Accept wildcard characters? false



<CommonParameters>

This cmdlet supports the common parameters: Verbose, Debug,

ErrorAction, ErrorVariable, WarningAction, WarningVariable,

OutBuffer, PipelineVariable, and OutVariable. For more information, see

about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).



INPUTS

Microsoft.PowerBI.Common.Api.Datasets.Dataset







OUTPUTS

System.Object







NOTES









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



RELATED LINKS