Muokkaa

Jaa


Get-PowerBIDataflowDatasource

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