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 ...
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

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