cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
tbolon Frequent Visitor
Frequent Visitor

Unable to update dataset credentials after importing a new report to power bi embedded

Since tuesday I am receiving an error when I use PowerBI-Cli nodejs package tool to update the connection credentials after importing a new report.

 

See the log below :

 

C:\Users\Thomas\...\pbi-embedded>powerbi update-connection -u ... -p "..." -d 38ada4a1-bcb7-4af2-82a1-e99a3c276352
[ powerbi ] Found dataset!
[ powerbi ] Id: 38ada4a1-bcb7-4af2-82a1-e99a3c276352
[ powerbi ] Name: ...
[ powerbi ] Getting gateway datasources...
[ powerbi ] Found 1 Datasources for Dataset 38ada4a1-bcb7-4af2-82a1-e99a3c276352
[ powerbi ] --------------------------------------------------------------------
[ powerbi ] Datesource ID:  21b67924-a383-45ad-847f-a4ec23a01510
[ powerbi ] Gateway ID:  75d9607b-ff46-4dbc-bc66-a5595c4289c1
[ powerbi ] Credential Type:  undefined
[ powerbi ] Datasource Type:  Sql
[ powerbi ] Updating datasource credentials...
[ powerbi ] Method:  PATCH
[ powerbi ] Url:  https://api.powerbi.com/v1.0/collections/.../workspaces/.../gateways/75d9607b-ff46-4dbc-bc66-a5595c4289c1/datasources/21b67924-a383-45ad-847f-a4ec23a01510
[ powerbi ] Status Code:  404
[ powerbi ] cache-control :  no-store, must-revalidate, no-cache
[ powerbi ] transfer-encoding :  chunked
[ powerbi ] content-type :  application/octet-stream
[ powerbi ] server :  Microsoft-HTTPAPI/2.0,Microsoft-HTTPAPI/2.0 Microsoft-HTTPAPI/2.0
[ powerbi ] strict-transport-security :  max-age=31536000; includeSubDomains
[ powerbi ] x-frame-options :  deny
[ powerbi ] x-content-type-options :  nosniff
[ powerbi ] requestid :  ea45634d-9003-4ac5-a15a-9677e61a3e2a
[ powerbi ] date :  Wed, 21 Dec 2016 20:14:42 GMT
[ powerbi ] connection :  close

C:\Users\Thomas\...\pbi-embedded>
1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-qiuyu-msft
Moderator

Re: Unable to update dataset credentials after importing a new report to power bi embedded

Based on my test today, I'm able to use PowerBI-Cli to update the dataset credential now. Please try again in your environment to see if issue is gone.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
9 REPLIES 9
Claus Frequent Visitor
Frequent Visitor

Re: Unable to update dataset credentials after importing a new report to power bi embedded

I have encountered same issues. It doesn't work as before. Any problems from Microsoft side? 

Claus Frequent Visitor
Frequent Visitor

Re: Unable to update dataset credentials after importing a new report to power bi embedded

What do you want to do?
=================================================================
1. Provision a new workspace collection
2. Get workspace collection metadata
3. Retrieve a workspace collection's API keys
4. Get list of workspaces within a collection
5. Provision a new workspace in an existing workspace collection
6. Import PBIX Desktop file into an existing workspace
7. Update connection string info for an existing dataset
8. Retrieve a list of Datasets published to a workspace
9. Delete a published dataset from a workspace
0. Get status of import

Dataset Id:4fbfd0d5-04ac-446e-9da0-b5cb03e49b3f

Username: ASNC

Password: *********
Connection String (enter to skip):

 

Ooops, something broke: Microsoft.Rest.HttpOperationException: Operation returned an invalid status code 'NotFound'
at Microsoft.PowerBI.Api.V1.Gateways.<PatchDatasourceWithHttpMessagesAsync>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.<PatchDatasourceAsync>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.<UpdateConnection>d__27.MoveNext() in C:\Users\chiah\Desktop\Embeded\power-bi-embedded-integrate-report-into-web-app-master\ProvisionSample\Program.cs:line 624
--- 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.<Run>d__17.MoveNext() in C:\Users\chiah\Desktop\Embeded\power-bi-embedded-integrate-report-into-web-app-master\ProvisionSample\Program.cs:line 239

mcp84 Occasional Visitor
Occasional Visitor

Re: Unable to update dataset credentials after importing a new report to power bi embedded

Im noted the same issue -  Im using . NET Microsoft.PowerBI.Api  and the same problem in function PatchDatasource - looks like Rest API for patch datasources stop working. Other functions which I use works like before.

 

Claus Frequent Visitor
Frequent Visitor

Re: Unable to update dataset credentials after importing a new report to power bi embedded

When can this be solved? We deployed powerbi embeded in our platform & some of the clients are using it now. Without PatchDatasource function, I wouldn't be able to update credential of new dataset. Please help.

avdknijff Frequent Visitor
Frequent Visitor

Re: Unable to update dataset credentials after importing a new report to power bi embedded

I Encouter the same problems, I'm unable to update the connection strings for the powerbi embeded service. The following error appears: Ooops, something broke: Microsoft.Rest.HttpOperationException: Operation returned an invalid status code 'NotFound'

Does anyone have a solution yet?

cuongle Member
Member

Re: Unable to update dataset credentials after importing a new report to power bi embedded

I got the same problem today as well, it seem Power BI Embedded REST API does work with method `PatchDatasource`

Moderator v-qiuyu-msft
Moderator

Re: Unable to update dataset credentials after importing a new report to power bi embedded

Based on my test today, I'm able to use PowerBI-Cli to update the dataset credential now. Please try again in your environment to see if issue is gone.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
avdknijff Frequent Visitor
Frequent Visitor

Re: Unable to update dataset credentials after importing a new report to power bi embedded

Hi, I'm happy to report that the issue seems to be resolved. Smiley Happy

tbolon Frequent Visitor
Frequent Visitor

Re: Unable to update dataset credentials after importing a new report to power bi embedded

Hi, the problem seems to be solved for me too.

 

You can mark this issue as solved.