Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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>
Solved! Go to Solution.
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
Hi, the problem seems to be solved for me too.
You can mark this issue as solved.
Hi, I'm happy to report that the issue seems to be resolved. 🙂
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
I got the same problem today as well, it seem Power BI Embedded REST API does work with method `PatchDatasource`
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?
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.
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.
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
I have encountered same issues. It doesn't work as before. Any problems from Microsoft side?
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |