Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Reporting Services PowerShell: Setting DataSource of a PowerbiReport

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

API
PowerShell
ReportServer
  • Anonymous's avatar
    Anonymous
    6 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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