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