Reporting Services PowerShell: Setting DataSource of a PowerbiReport

[Anonymous]

Hello,

I am trying to set the User and the Password of a Powerbi Dashboard via the PowerShell Reporting Services:

https://github.com/microsoft/ReportingServicesTools

If I am trying to get the DataSource of a PBIX Report, the count is 0.

$ds = Get-RsItemDataSource -proxy $Proxy -RsItem $dataSourcePath
$ds.Count

or  (from https://github.com/microsoft/ReportingServicesTools/blob/master/Tests/CatalogItems/Set-RsItemDataSou...)

$ds = Get-RsItemDataSource -Path $dataSourcePath -Proxy $proxy
$ds.Count

If I Change the ReportPath to something that does not exist, the whole script fails, so the Path should be correct.

What am I doing wrong?

Thanks and Best Regards

[Anonymous · Accepted solution]

HI,

i got a solution now. You need to access the Portal instead of the server:

$ReportServerUri = "http://<<ServerName>>/PBIReportServer"
$ReportPortalUri = "http://<<ServerName>>/PBIReports"
Get-RsRestItemDataSource -RsItem $dataSourcePath -ReportPortalUri $ReportPortalUri

 no I can access via:

foreach ($dataSource in $ds) {
$dataSource.DataModelDataSource.Username = "TestAPI"
}

and set it via:

Set-RsRestItemDataSource -RsItem $dataSourcePath -DataSource $ds -RsItemType PowerBIReport -ReportPortalUri $ReportPortalUri

Hope this helps someone else.

Best Regards