Get-PowerBIDataflowDatasource

Module:

MicrosoftPowerBIMgmt.Data Module

Returns a list of Power BI data sources for the given Dataflow.

Syntax

List (Default)

Get-PowerBIDataflowDatasource
    -DataflowId <Guid>
    [-WorkspaceId <Guid>]
    [-Scope <PowerBIUserScope>]
    [<CommonParameters>]

Id

Get-PowerBIDataflowDatasource
    -DataflowId <Guid>
    -Id <Guid>
    [-WorkspaceId <Guid>]
    [-Scope <PowerBIUserScope>]
    [<CommonParameters>]

DataflowAndId

Get-PowerBIDataflowDatasource
    -Dataflow <Dataflow>
    -Id <Guid>
    [-WorkspaceId <Guid>]
    [-Scope <PowerBIUserScope>]
    [<CommonParameters>]

DataflowAndList

Get-PowerBIDataflowDatasource
    -Dataflow <Dataflow>
    [-WorkspaceId <Guid>]
    [-Scope <PowerBIUserScope>]
    [<CommonParameters>]

Description

Retrieves a list of Power BI data sources under the specified dataflow that match the specified search criteria and scope. Data sources connected to Dataflows doesn't have a Name value, so there is no 'Name' parameter. For -Scope Individual, user must specify the dataflow's workspace, using the given -WorkspaceId value. Before you run this command, make sure you log in using Connect-PowerBIServiceAccount.

Examples

Example 1

PS C:\> Get-PowerBIDatasource -DataflowId 23d088a0-a395-483e-b81c-54f51f3e4e3c -WorkspaceId ed451706-2b02-430c-b25c-20c0842c6375

Returns all data sources in a Power BI dataflow with ID 23d088a0-a395-483e-b81c-54f51f3e4e3c, for a dataflow the calling user has access to in the given workspace.

Example 2

PS C:\> Get-PowerBIDatasource -DataflowId 23d088a0-a395-483e-b81c-54f51f3e4e3c -Scope Organization

Returns all data sources in a Power BI dataflow with ID 23d088a0-a395-483e-b81c-54f51f3e4e3c, for a dataflow in the calling user's organization.

Example 3

PS C:\> Get-PowerBIDatasource -DataflowId 23d088a0-a395-483e-b81c-54f51f3e4e3c -WorkspaceId ed451706-2b02-430c-b25c-20c0842c6375 -Id a3066be2-ea12-4ae2-b8e9-b8006b1fbf61

Returns a data source with ID a3066be2-ea12-4ae2-b8e9-b8006b1fbf61, in a dataflow with ID 23d088a0-a395-483e-b81c-54f51f3e4e3c the calling user has access to in the given workspace.

Example 4

PS C:\> Get-PowerBIDataflow -Scope Organization -Name "MyDataflow" | Get-PowerBIDatasource -Scope Organization

Returns all data sources in a Power BI dataflow with Name "MyDataflow", using a pipeline result from a call to Get-PowerBIDataflow.

Parameters

-Dataflow

Dataflow object to retrieve and return data sources for.

Parameter properties

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

Parameter sets

DataflowAndId

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

DataflowAndList

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

-DataflowId

ID of the dataflow to retrieve and return data sources for.

Parameter properties

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

Parameter sets

List

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

Id

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

-Id

ID of the data source to return.

Parameter properties

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

Parameter sets

Id

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

DataflowAndId

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 only data sources from dataflows assigned to the caller; Organization returns data sources for all dataflows 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

-WorkspaceId

ID of the workspace to filter results to. Only data sources belonging to that workspace are shown. Available only when -Scope is Individual.

Parameter properties

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

Parameter sets

(All)

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

Microsoft.PowerBI.Common.Api.Dataflows.Dataflow

Outputs

System.Object