Error when updating connection string

[proanalyticsdev]

I'm using the sample application to import a PBIX desktop file into an existing workspace. The import works fine but when I try to update the connection string, I get an error:
Ooops, something broke: Microsoft.Rest.HttpOperationException: Operation returned an invalid status code 'NotFound'
at Microsoft.PowerBI.Api.V1.Gateways.d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.Api.V1.GatewaysExtensions.d__1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()
at ProvisionSample.Program.d__28.MoveNext() in C:\Projects\power-bi-embedded-integrate-report-into-web-app-master\ProvisionSample\Program.cs:line 625
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.GetResult()
at ProvisionSample.Program.d__18.MoveNext() in C:\Projects\power-bi-embedded-integrate-report-into-web-app-master\ProvisionSample\Program.cs:line 240

Any idea what might be the problem?

[sheggem]

I also have the same issue. codeline : await client.Gateways.PatchDatasourceAsync(workspaceCollectionName, workspaceId, gatewayId, datasourceId, delta);
Database is Azure SQL

[johnanish]

getting the exact same error as mentioned. not sure why this is happening though.

[cruise-insights]

I am getting the same issue, it was working previously but has stopped now
Please Suggest some way to change credentials

[kiss96803]

I have get the same issues,Please Notify that error code has two result , one is 'BadRequest' And the other is 'NotFound'

[cruise-insights]

Hi, you can use the PowerBI Cli 1.0.4 available in NPM for Provisioning (Including Update-Connection) , it works.

In .NET the SetAllConnectionAsync Call fails with Bad Request, I assume the API and Parameter Definition/Usage has changed in the .NET SDK

[kiss96803]

@cruise-insights Thanks a lot, It really works. I have the same opinion with you ,There are some conflicts in sdk and the Introduction to the official website need to update。

[cruise-insights]

@magnusjohannesson , @johnanish , @sheggem , @paulbatum

Did the error resolve?

[proanalyticsdev]

Yes, it was a Microsoft issue and they have corrected it.