change connection string via power shell bad request error

[OPB12]

Hi,

I use the script to change data source .

Change data source connection strings with PowerShell - Power BI Report Server pre-October 2020 - Po...

but i am getting this error , i use PBIRS Version: 2.97.863.0 64-bit (September, 2021) and powershell 0.0.7.2

WARNING: No XSRF Token detected! This might be due to XSRF token disabled.
Failed to update data sources for '/Test=/test-Import_IT': The remote server returned an error: (400) Bad Request.
At C:\Program Files\WindowsPowerShell\Modules\reportingservicestools\Functions\CatalogItems\Rest\Set-RsRestItemDataSource.ps1:256 char:13
+ throw (New-Object System.Exception("Failed to update data ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : OperationStopped: (:) [], Exception
+ FullyQualifiedErrorId : Failed to update data sources for '/Test/test-Import_IT': The remote server returned an error: (400) Bad Request.

[Sahir_Maharaj]

It's also possible that the issue is related to the version of Power BI Report Server that you're using, or the version of PowerShell that you're using to run the script. Ensure that both are up-to-date and supported.

[Sahir_Maharaj]

There can be multiple reasons for this error, including incorrect URL, incorrect header values, incorrect request body, etc. To resolve this issue, you can try the following:

1. Verify the URL being used to make the REST call. Ensure that it's correct and points to the correct Power BI Report Server instance.

2. Verify the header values being used in the REST call. Ensure that they're correct and match the expected format.

3. Verify the request body being sent with the REST call. Ensure that it contains the correct values and that they match the expected format.

[Sahir_Maharaj]

The error you're encountering suggests that there's a problem with the REST call that you're making to update the data source connection string. The message "The remote server returned an error: (400) Bad Request." is indicating that the server received a request that it could not understand or process.