Error on updating dataset connection after importing a report to power bi embedded with CLI

[wei]

I received an error when I use PowerBI Cli nodejs package tool to update the connection credentials after importing a report.

See the log below  and please hlep:

[ powerbi ] Found dataset!
[ powerbi ] Id: xxxxxxxxxxxxxxxx
[ powerbi ] Name: xxxxxx
[ powerbi ] Updating connection string...
[ powerbi ] Getting gateway datasources...
[ powerbi ] Connection string is not valid
[ powerbi ] Method:  POST
[ powerbi ] Url:  https://api.powerbi.com/v1.0/collections/xxxx/workspaces/%20xxxxx/datasets/xxxxxxxxxxxxxx/Default.SetAllConnections
[ powerbi ] Status Code:  400
[ powerbi ] cache-control :  no-store, must-revalidate, no-cache
[ powerbi ] transfer-encoding :  chunked
[ powerbi ] content-type :  application/json; charset=utf-8
[ powerbi ] server :  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 :  e36a4e65-13bb-4518-92e3-04dfe58c39e6
[ powerbi ] date :  Mon, 22 May 2017 06:01:28 GMT
[ powerbi ] connection :  close
[ powerbi ] Connection string successfully updated
[ powerbi ] Dataset:  xxxxxxxxxxxx
[ powerbi ] ConnectionString:  Server=tcp:xxxxx.database.windows.net,1433;Database=xxxx;User ID=xxxxxxxxx;Password=xx;Trusted_Connection=False;Encrypt=True;Connection Timeout=30;
[ powerbi ] {"error":{"code":"DMTS_MonikerNotFoundError","pbi.error":{"code":"DMTS_MonikerNotFoundError","parameters":{},"details":[]}}}
[ powerbi ] Method:  GET
[ powerbi ] Url:  https://api.powerbi.com/v1.0/collections/xxxxxx/workspaces/%20xxxxxxxxx/datasets/xxxxxx/Default.GetBoundGatewayDatasources
[ powerbi ] Status Code:  404
[ powerbi ] cache-control :  no-store, must-revalidate, no-cache
[ powerbi ] transfer-encoding :  chunked
[ powerbi ] content-type :  application/json; charset=utf-8
[ powerbi ] server :  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 :  f5774f86-6569-4fe1-8aaf-f0954ff669d4
[ powerbi ] date :  Mon, 22 May 2017 06:01:28 GMT
[ powerbi ] connection :  close

[devbv]

Hi, I am facing a similar issue with the DMTS_MonikerNotFoundError code being thrown. However, I was wondering where you get the log as in your post please?

[Eric_Zhang · Accepted solution]

---

@wei wrote:

I received an error when I use PowerBI Cli nodejs package tool to update the connection credentials after importing a report.

See the log below  and please hlep:

[ powerbi ] Found dataset!
[ powerbi ] Id: xxxxxxxxxxxxxxxx
[ powerbi ] Name: xxxxxx
[ powerbi ] Updating connection string...
[ powerbi ] Getting gateway datasources...
[ powerbi ] Connection string is not valid
[ powerbi ] Method:  POST
[ powerbi ] Url:  https://api.powerbi.com/v1.0/collections/xxxx/workspaces/%20xxxxx/datasets/xxxxxxxxxxxxxx/Default.SetAllConnections
[ powerbi ] Status Code:  400
[ powerbi ] cache-control :  no-store, must-revalidate, no-cache
[ powerbi ] transfer-encoding :  chunked
[ powerbi ] content-type :  application/json; charset=utf-8
[ powerbi ] server :  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 :  e36a4e65-13bb-4518-92e3-04dfe58c39e6
[ powerbi ] date :  Mon, 22 May 2017 06:01:28 GMT
[ powerbi ] connection :  close
[ powerbi ] Connection string successfully updated
[ powerbi ] Dataset:  xxxxxxxxxxxx
[ powerbi ] ConnectionString:  Server=tcp:xxxxx.database.windows.net,1433;Database=xxxx;User ID=xxxxxxxxx;Password=xx;Trusted_Connection=False;Encrypt=True;Connection Timeout=30;
[ powerbi ] {"error":{"code":"DMTS_MonikerNotFoundError","pbi.error":{"code":"DMTS_MonikerNotFoundError","parameters":{},"details":[]}}}
[ powerbi ] Method:  GET
[ powerbi ] Url:  https://api.powerbi.com/v1.0/collections/xxxxxx/workspaces/%20xxxxxxxxx/datasets/xxxxxx/Default.GetBoundGatewayDatasources
[ powerbi ] Status Code:  404
[ powerbi ] cache-control :  no-store, must-revalidate, no-cache
[ powerbi ] transfer-encoding :  chunked
[ powerbi ] content-type :  application/json; charset=utf-8
[ powerbi ] server :  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 :  f5774f86-6569-4fe1-8aaf-f0954ff669d4
[ powerbi ] date :  Mon, 22 May 2017 06:01:28 GMT
[ powerbi ] connection :  close

---

@wei

The API SetAllConnections is currently working based on my test. The error in your case is intuitive, a valid connection string is like

data source=xxxx.database.windows.net;initial catalog=xxxxxdbname;persist security info=True;User id = userxxx;Password = Password01!;encrypt=True;trustservercertificate=False