Edit

Share via

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