Reporting Services PowerShell: Setting DataSource of a PowerbiReport

Anonymous — Wed, 15 Apr 2020 06:24:20 GMT

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-RsItemDataSource.Tests.ps1)

$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

Re: Reporting Services PowerShell: Setting DataSource of a PowerbiReport

Anonymous — Wed, 15 Apr 2020 06:47:49 GMT

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

topic Re: Reporting Services PowerShell: Setting DataSource of a PowerbiReport in Report Server

Reporting Services PowerShell: Setting DataSource of a PowerbiReport

Re: Reporting Services PowerShell: Setting DataSource of a PowerbiReport