topic Re: ReportingServicesTools Set-RsRestItemDataSource - BAD REQUEST how to diagnose? in Report Server

ReportingServicesTools Set-RsRestItemDataSource - BAD REQUEST how to diagnose?

IbisRipley — Fri, 27 May 2022 15:36:10 GMT

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

returns

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"


cls

#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("mydomain.com", "mydomain.com.999")
$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
}

Re: ReportingServicesTools Set-RsRestItemDataSource - BAD REQUEST how to diagnose?

IbisRipley — Fri, 27 May 2022 15:57:22 GMT

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

Re: ReportingServicesTools Set-RsRestItemDataSource - BAD REQUEST how to diagnose?

IbisRipley — Fri, 27 May 2022 18:58:24 GMT

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

Build File version Description Release date

15.0.1108.159

1.13.8086.22725

Power BI Report Server January 2022 Update Download

2022-02-23 *new

IS it possible that this method (Parameters ) https://docs.microsoft.com/en-us/power-bi/report-server/connect-data-source-apis would ned to be used since the method above ( from here https://docs.microsoft.com/en-us/power-bi/report-server/connect-data-source-apis <-- 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?

Re: ReportingServicesTools Set-RsRestItemDataSource - BAD REQUEST how to diagnose?

Anonymous — Tue, 31 May 2022 02:15:05 GMT

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

Re: ReportingServicesTools Set-RsRestItemDataSource - BAD REQUEST how to diagnose?

DustinKeith — Thu, 03 Nov 2022 20:27:45 GMT

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.

Re: ReportingServicesTools Set-RsRestItemDataSource - BAD REQUEST how to diagnose?

OPB12 — Tue, 31 Jan 2023 17:11:59 GMT

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