Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

ReportingServicesTools Set-RsRestItemDataSource - BAD REQUEST how to diagnose?

I am attempting to write a script to update Datasource connect strings for power bi reports on PBIRS(on prem, no service)  - Trying to add a port to the ( sharepoint ) url in the connect string.  Forgive me as I am new to this and unsure how to move forward.  Script is below and it does return the connectstring with the port to screen prior to setting it.    Can anyone help with possible next steps or what might be wrong?  Thanks in advance

The last line

Set-RsRestItemDataSource -RsItem $dataSourcePath -RsItemType 'PowerBIReport' -DataSources $ds -ReportPortalUri $ReportServerURI


Failed to update data sources for '/AP/CSECR/Action%20Items': The remote server returned an error: (400) Bad Request.
$ReportServerURI = "https://<svr>/Reports/"
$ReportPortalUri = "https://<svr>//PBIReports"

$dataSourcePath = "/MyReportPath"


#Get-RsRestItemDataSource -RsItem $dataSourcePath -ReportPortalUri $ReportPortalUri

$dataSources = Get-RsRestItemDataSource -RsItem $dataSourcePath -ReportPortalUri $ReportServerUri
foreach($ds in $dataSources)
Write-Host $ds.ConnectionString

$ds.ConnectionString = $ds.ConnectionString.Replace("", "")
$ds.DataModelDataSource.AuthType = "Integrated"
$ds.DataModelDataSource.Username = "Adomain\user"
$ds.DataModelDataSource.Secret = "mypw"

Write-Host $ds.ConnectionString

Set-RsRestItemDataSource -RsItem $dataSourcePath -RsItemType 'PowerBIReport' -DataSources $ds -ReportPortalUri $ReportServerURI




New Member

I am having the same issue.  I can set many of the values (e. g. Name, Description, DataModelDataSource.AuthType, DataModelDataSource.Username) but, as soon as I add in the DataModelDataSource.Secret = "mypw" it results in the Bad Request (400) error.

That rules out the cerdentials being wrong/expired.  I have tried setting the CredentialRetrieval to "prompt" and "store" with no success.

Community Support
Community Support

Hi @IbisRipley ,


Failed to update data sources for '/AP/CSECR/Action%20Items': The remote server returned an error: (400) Bad Request.

Have you checked the credentials? 400 usually indicates an incorrectly formatted query. In your case, however, this looks more like expired credentials.  


Best Regards,
Community Support Team _ Caitlyn

I am getting the same problem do you have any resolution ? 

Frequent Visitor

One additional note:  I managed to get the Response body, but it doesn't help me much either.  

Response body:
Failed to update data sources for '/AP/CSECR/Action%20Items': The remote server returned an error: (400) Bad Request.
+ CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException
+ FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException

In Hopes of getting some help, here is more information.   We are on 

Build File version Description Release date

15.0.1108.1591.13.8086.22725Power BI Report Server January 2022 Update Download2022-02-23 *new


IS it possible that this method (Parameters )   would ned to be used since the method above ( from here <-- specifies pre-OCT 2020) would need to be used?   It seems if that is the case we would need to manually modify all reports to add parameters?

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.