Get-PowerBIDataflowDatasource

Reference

Module:: MicrosoftPowerBIMgmt.Data

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

Syntax

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

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

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

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.

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

-DataflowId

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

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

-Id

ID of the data source to return.

Type:	Guid
Aliases:	DatasourceId
Position:	Named
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	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.

Type:	PowerBIUserScope
Accepted values:	Individual, Organization
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	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.

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

Inputs

Microsoft.PowerBI.Common.Api.Dataflows.Dataflow

Outputs

System.Object