Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
tbolon
Advocate I
Advocate I

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
v-qiuyu-msft
Community Support
Community Support

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.

View solution in original post

9 REPLIES 9
tbolon
Advocate I
Advocate I

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

 

You can mark this issue as solved.

avdknijff
Frequent Visitor

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

v-qiuyu-msft
Community Support
Community Support

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.
cuongle
Advocate II
Advocate II

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

avdknijff
Frequent Visitor

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?

Claus
Frequent Visitor

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.

mcp84
New Member

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

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

Claus
Frequent Visitor

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.