< Back

Get-PowerBIDatasource

Sat Jan 18, 2020 4:13 pm

NAME Get-PowerBIDatasource



SYNOPSIS

Returns a list of Power BI data sources.





SYNTAX

Get-PowerBIDatasource -Dataset <Dataset> -Id <Guid> [-Scope {Individual | Organization}] [-WorkspaceId <Guid>]

[<CommonParameters>]



Get-PowerBIDatasource -Dataset <Dataset> -Name <String> [-Scope {Individual | Organization}] [-WorkspaceId <Guid>]

[<CommonParameters>]



Get-PowerBIDatasource -Dataset <Dataset> [-Scope {Individual | Organization}] [-WorkspaceId <Guid>]

[<CommonParameters>]



Get-PowerBIDatasource -DatasetId <Guid> [-Scope {Individual | Organization}] [-WorkspaceId <Guid>]

[<CommonParameters>]



Get-PowerBIDatasource -DatasetId <Guid> -Id <Guid> [-Scope {Individual | Organization}] [-WorkspaceId <Guid>]

[<CommonParameters>]



Get-PowerBIDatasource -DatasetId <Guid> -Name <String> [-Scope {Individual | Organization}] [-WorkspaceId <Guid>]

[<CommonParameters>]





DESCRIPTION

Retrieves a list of Power BI data sources under the specified dataset along that match the specified search

criteria and scope. Before you run this command, make sure you log in using Connect-PowerBIServiceAccount.





PARAMETERS

-Dataset <Dataset>

Dataset for returning data sources for.



Required? true

Position? named

Default value None

Accept pipeline input? True (ByValue)

Accept wildcard characters? false



-DatasetId <Guid>

ID of the dataset to 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



-Name <String>

Name of the data source to return if one exists with that name. Case insensitive search.



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 assigned to the caller; Organization returns

all data sources 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, data sources only belonging to that workspace are shown. Only

available 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.Datasets.Dataset







OUTPUTS

System.Object







NOTES









-------------------------- Example 1 --------------------------



PS C:\\> Get-PowerBIDatasource -DatasetId 23d088a0-a395-483e-b81c-54f51f3e4e3c



Returns all data sources in Power BI dataset with ID 23d088a0-a395-483e-b81c-54f51f3e4e3c, for dataset the calling

user has access to.

-------------------------- Example 2 --------------------------



PS C:\\> Get-PowerBIDatasource -DatasetId 23d088a0-a395-483e-b81c-54f51f3e4e3c -Scope Organization



Returns all data sources in Power BI dataset with ID 23d088a0-a395-483e-b81c-54f51f3e4e3c, for a dataset in the

calling user's organization.



RELATED LINKS

Online Version:

https://docs.microsoft.com/en-us/powers ... powerbi-ps