Edit

Share via

Get-PowerBIDataset

Module:
MicrosoftPowerBIMgmt.Data Module

Returns a list of Power BI datasets.

Syntax

List (Default) 

Get-PowerBIDataset
    [-Scope <PowerBIUserScope>]
    [-Filter <String>]
    [-First <Int32>]
    [-Include <String>]
    [-Skip <Int32>]
    [-WorkspaceId <Guid>]
    [<CommonParameters>]

Id 

Get-PowerBIDataset
    -Id <Guid>
    [-Scope <PowerBIUserScope>]
    [-Include <String>]
    [-WorkspaceId <Guid>]
    [<CommonParameters>]

ObjectAndId 

Get-PowerBIDataset
    -Id <Guid>
    -Workspace <Workspace>
    [-Scope <PowerBIUserScope>]
    [-Include <String>]
    [<CommonParameters>]

Name 

Get-PowerBIDataset
    -Name <String>
    [-Scope <PowerBIUserScope>]
    [-Include <String>]
    [-WorkspaceId <Guid>]
    [<CommonParameters>]

ObjectAndName 

Get-PowerBIDataset
    -Name <String>
    -Workspace <Workspace>
    [-Scope <PowerBIUserScope>]
    [-Include <String>]
    [<CommonParameters>]

ObjectAndList 

Get-PowerBIDataset
    -Workspace <Workspace>
    [-Scope <PowerBIUserScope>]
    [-First <Int32>]
    [-Include <String>]
    [-Skip <Int32>]
    [<CommonParameters>]

Description

Retrieves a list of Power BI datasets that match the specified search criteria and scope. Before you run this command, make sure you log in using Connect-PowerBIServiceAccount. For -Scope Individual, datasets are returned from "My Workspace" unless -Workspace or -WorkspaceId is specified.

Examples

Example 1

PS C:\> Get-PowerBIDataset

Returns a list of all Power BI datasets a user has access to.

Example 2

PS C:\> Get-PowerBIDataset -Scope Organization

Returns a list of all Power BI datasets within a user's organization.

Parameters

-Filter

OData filter, case-sensitive (element names start lowercase). Only supported when -Scope Organization is specified.

Parameter properties

Type:String
Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

List
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-First

First (top) list of results.

Parameter properties

Type:Int32
Default value:None
Supports wildcards:False
DontShow:False
Aliases:Top

Parameter sets

List
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ObjectAndList
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-Id

ID of the dataset to return.

Parameter properties

Type:Guid
Default value:None
Supports wildcards:False
DontShow:False
Aliases:DatasetId

Parameter sets

Id
Position:Named
Mandatory:True
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ObjectAndId
Position:Named
Mandatory:True
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-Include

OData expand, case-sensitive (element names start lowercase).

Parameter properties

Type:String
Default value:None
Accepted values:actualStorage
Supports wildcards:False
DontShow:False
Aliases:Expand

Parameter sets

(All)
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-Name

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

Parameter properties

Type:String
Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

Name
Position:Named
Mandatory:True
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ObjectAndName
Position:Named
Mandatory:True
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-Scope

Indicates scope of the call. Individual returns datasets from "My Workspace" by default. With -Workspace or -WorkspaceId, datasets under the workspace assigned to the caller are returned; Organization returns all datasets within a tenant (must be an administrator to initiate). Individual is the default.

Parameter properties

Type:PowerBIUserScope
Default value:None
Accepted values:Individual, Organization
Supports wildcards:False
DontShow:False

Parameter sets

(All)
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-Skip

Skips the first set of results.

Parameter properties

Type:Int32
Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

List
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ObjectAndList
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-Workspace

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

Parameter properties

Type:Workspace
Default value:None
Supports wildcards:False
DontShow:False
Aliases:Group

Parameter sets

ObjectAndId
Position:Named
Mandatory:True
Value from pipeline:True
Value from pipeline by property name:False
Value from remaining arguments:False
ObjectAndName
Position:Named
Mandatory:True
Value from pipeline:True
Value from pipeline by property name:False
Value from remaining arguments:False
ObjectAndList
Position:Named
Mandatory:True
Value from pipeline:True
Value from pipeline by property name:False
Value from remaining arguments:False

-WorkspaceId

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

Parameter properties

Type:Guid
Default value:None
Supports wildcards:False
DontShow:False
Aliases:GroupId

Parameter sets

List
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
Id
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
Name
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

CommonParameters

This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutBuffer, -OutVariable, -PipelineVariable, -ProgressAction, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.

Inputs

None

Outputs

System.Object