Update-PBIDatasetDatasources

NAME Update-PBIDatasetDatasources



SYNOPSIS

Update the datasource of a dataset





SYNTAX

Update-PBIDatasetDatasources [[-authToken] <String>] [-dataset] <Object> [-datasourceType] <Object>

[-originalServer] <Object> [-originalDatabase] <Object> [-targetServer] <Object> [-targetDatabase] <Object>

[[-groupId] <String>] [<CommonParameters>]





DESCRIPTION

Changes the connection string of an existing dataset in PowerBI





PARAMETERS

-authToken <String>

The authorization token required to comunicate with the PowerBI APIs

Use 'Get-PBIAuthToken' to get the authorization token string



Required? false

Position? 1

Default value

Accept pipeline input? false

Accept wildcard characters? false



-dataset <Object>



Required? true

Position? 2

Default value

Accept pipeline input? true (ByValue)

Accept wildcard characters? false



-datasourceType <Object>

The type of the datasource. The type cannot be changed from original to target.

e.g. "AnalysisServices" or "Sql"



Required? true

Position? 3

Default value

Accept pipeline input? false

Accept wildcard characters? false



-originalServer <Object>

Original server.



Required? true

Position? 4

Default value

Accept pipeline input? false

Accept wildcard characters? false



-originalDatabase <Object>

Original database.



Required? true

Position? 5

Default value

Accept pipeline input? false

Accept wildcard characters? false



-targetServer <Object>

New Server.



Required? true

Position? 6

Default value

Accept pipeline input? false

Accept wildcard characters? false



-targetDatabase <Object>

New database.



Required? true

Position? 7

Default value

Accept pipeline input? false

Accept wildcard characters? false



-groupId <String>



Required? false

Position? 8

Default value

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



OUTPUTS



-------------------------- EXAMPLE 1 --------------------------



PS C:\\>Update-PBIDatasetDatasources -dataset xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx -datasourceType AnalysisServices

-originalServer "asazure://eastus.asazure.windows.net/myssas" -originalDatabase "wideworldimporters"

-targetServer "asazure://eastus.asazure.windows.net/myssas" -targetDatabase "wideworldimporters2"













-------------------------- EXAMPLE 2 --------------------------



PS C:\\>Get-PBIDataSet -name "DS Name" | Update-PBIDatasetDatasources -datasourceType AnalysisServices

-originalServer "asazure://eastus.asazure.windows.net/myssas" -originalDatabase "wideworldimporters"

-targetServer "asazure://eastus.asazure.windows.net/myssas" -targetDatabase "wideworldimporters2"















RELATED LINKS