< Back

Set-PBIReportsDataset

Sat Jan 18, 2020 8:44 pm

NAME Set-PBIReportsDataset



SYNOPSIS

Rebind reports to another dataset on the same workspace.





SYNTAX

Set-PBIReportsDataset [-authToken <String>] -report <Object> -targetDatasetId <String> [-timeout <Int32>]

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



Set-PBIReportsDataset [-authToken <String>] -sourceDatasetId <Object> -targetDatasetId <String> [-timeout <Int32>]

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





DESCRIPTION





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? named

Default value

Accept pipeline input? false

Accept wildcard characters? false



-report <Object>

The PBI Report Object or Report Id (GUID)



Required? true

Position? named

Default value

Accept pipeline input? true (ByValue)

Accept wildcard characters? false



-sourceDatasetId <Object>

A string with the source dataset id, when executed with this parameter all the reports that target the source

dataset will be rebinded



Required? true

Position? named

Default value

Accept pipeline input? false

Accept wildcard characters? false



-targetDatasetId <String>

A string with the new dataset id to bind the reports



Required? true

Position? named

Default value

Accept pipeline input? false

Accept wildcard characters? false



-timeout <Int32>



Required? false

Position? named

Default value 300

Accept pipeline input? false

Accept wildcard characters? false



-groupId <String>



Required? false

Position? named

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:\\>Set-PBIReportsDataset -report "ReportId" -targetDatasetId "DataSetId"













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



PS C:\\>Get-PBIReport | Set-PBIReportsDataset -targetDatasetId "DataSetId"













-------------------------- EXAMPLE 3 --------------------------



PS C:\\># Rebind all the reports from Source DataSet to the Target DataSet



Set-PBIReportsDataset -sourceDatasetId "SourceDataSetId" -targetDatasetId "DataSetId"











RELATED LINKS