< Back
Get-PowerBIDataflowDatasource
Post
NAME Get-PowerBIDataflowDatasource
SYNOPSIS
Returns a list of Power BI data sources for the given Dataflow.
SYNTAX
Get-PowerBIDataflowDatasource -Dataflow <Dataflow> -Id <Guid> [-Scope {Individual | Organization}] [-WorkspaceId
<Guid>] [<CommonParameters>]
Get-PowerBIDataflowDatasource -Dataflow <Dataflow> [-Scope {Individual | Organization}] [-WorkspaceId <Guid>]
[<CommonParameters>]
Get-PowerBIDataflowDatasource -DataflowId <Guid> [-Scope {Individual | Organization}] [-WorkspaceId <Guid>]
[<CommonParameters>]
Get-PowerBIDataflowDatasource -DataflowId <Guid> -Id <Guid> [-Scope {Individual | Organization}] [-WorkspaceId
<Guid>] [<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.
PARAMETERS
-Dataflow <Dataflow>
Dataflow object to retrieve and return data sources for.
Required? true
Position? named
Default value None
Accept pipeline input? True (ByValue)
Accept wildcard characters? false
-DataflowId <Guid>
ID of the dataflow to retrieve and return data sources for.
Required? true
Position? named
Default value None
Accept pipeline input? False
Accept wildcard characters? false
-Id <Guid>
ID of the data source to return.
Required? true
Position? named
Default value None
Accept pipeline input? False
Accept wildcard characters? false
-Scope <PowerBIUserScope>
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.
Required? false
Position? named
Default value None
Accept pipeline input? False
Accept wildcard characters? false
-WorkspaceId <Guid>
ID of the workspace to filter results to. Only data sources belonging to that workspace are shown. Available
only when -Scope is Individual.
Required? false
Position? named
Default value None
Accept pipeline input? False
Accept wildcard characters? false
<CommonParameters>
This cmdlet supports the common parameters: Verbose, Debug,
ErrorAction, ErrorVariable, WarningAction, WarningVariable,
OutBuffer, PipelineVariable, and OutVariable. For more information, see
about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).
INPUTS
Microsoft.PowerBI.Common.Api.Dataflows.Dataflow
OUTPUTS
System.Object
NOTES
-------------------------- 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.
RELATED LINKS
Online Version: https://docs.microsoft.com/en-us/powers ... ataflowdat
asource?view=powerbi-ps
SYNOPSIS
Returns a list of Power BI data sources for the given Dataflow.
SYNTAX
Get-PowerBIDataflowDatasource -Dataflow <Dataflow> -Id <Guid> [-Scope {Individual | Organization}] [-WorkspaceId
<Guid>] [<CommonParameters>]
Get-PowerBIDataflowDatasource -Dataflow <Dataflow> [-Scope {Individual | Organization}] [-WorkspaceId <Guid>]
[<CommonParameters>]
Get-PowerBIDataflowDatasource -DataflowId <Guid> [-Scope {Individual | Organization}] [-WorkspaceId <Guid>]
[<CommonParameters>]
Get-PowerBIDataflowDatasource -DataflowId <Guid> -Id <Guid> [-Scope {Individual | Organization}] [-WorkspaceId
<Guid>] [<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.
PARAMETERS
-Dataflow <Dataflow>
Dataflow object to retrieve and return data sources for.
Required? true
Position? named
Default value None
Accept pipeline input? True (ByValue)
Accept wildcard characters? false
-DataflowId <Guid>
ID of the dataflow to retrieve and return data sources for.
Required? true
Position? named
Default value None
Accept pipeline input? False
Accept wildcard characters? false
-Id <Guid>
ID of the data source to return.
Required? true
Position? named
Default value None
Accept pipeline input? False
Accept wildcard characters? false
-Scope <PowerBIUserScope>
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.
Required? false
Position? named
Default value None
Accept pipeline input? False
Accept wildcard characters? false
-WorkspaceId <Guid>
ID of the workspace to filter results to. Only data sources belonging to that workspace are shown. Available
only when -Scope is Individual.
Required? false
Position? named
Default value None
Accept pipeline input? False
Accept wildcard characters? false
<CommonParameters>
This cmdlet supports the common parameters: Verbose, Debug,
ErrorAction, ErrorVariable, WarningAction, WarningVariable,
OutBuffer, PipelineVariable, and OutVariable. For more information, see
about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).
INPUTS
Microsoft.PowerBI.Common.Api.Dataflows.Dataflow
OUTPUTS
System.Object
NOTES
-------------------------- 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.
RELATED LINKS
Online Version: https://docs.microsoft.com/en-us/powers ... ataflowdat
asource?view=powerbi-ps