Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

0
wei

Unable to update the connection credentials with PowerBI Cli

Submitted by on ‎05-20-2017 07:54 AM

I got an error when I use PowerBI-Cli nodejs package tool to update the connection credentials after importing a new report on mooncake(endpoint: https://WABI-MC-BJB-redirect.analysis.chinacloudapi.cn). Next is command I run and log , please help!!

powerbi update-connection -c $WorkspaceCollectionName -w $workspaceId -k $appkey -d $datasetID -s $dbConnection -u $dbName -p $VMPassword -b $PBIApiEndpoint

[ powerbi ] Found dataset!
[ powerbi ] Id: 8b295d45-1993-4584-b3be-0bee55a2ed55
[ powerbi ] Name: xxxxxx
[ powerbi ] Updating connection string...
[ powerbi ] Getting gateway datasources...
[ powerbi ] {"error":{"code":"DMTS_MonikerNotFoundError","pbi.error":{"code":"DMTS_MonikerNotFoundError","parameters":{},"details":[]}}}
[ powerbi ] Method:  GET
[ powerbi ] Url:  https://WABI-MC-BJB-redirect.analysis.chinacloudapi.cn/v1.0/collections/xxxxx/workspaces/%20xxxxxx/datasets/xxxxx/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 :  ecea4301-8268-4dd4-8984-cae2fd10bde2
[ powerbi ] date :  Sat, 20 May 2017 14:17:23 GMT
[ powerbi ] connection :  close
[ powerbi ] Connection string is not valid
[ powerbi ] Method:  POST
[ powerbi ] Url:  https://WABI-MC-BJB-redirect.analysis.chinacloudapi.cn/v1.0/collections/xxxxx/workspaces/%20xxxx/datasets/xxxx/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 :  4502bc4c-3063-4a2f-958a-e53f47313929
[ powerbi ] date :  Sat, 20 May 2017 14:17:24 GMT
[ powerbi ] connection :  close
[ powerbi ] Connection string successfully updated
[ powerbi ] Dataset:  xxxxxxx
[ powerbi ] ConnectionString:  Server=tcp:xxxxx.database.chinacloudapi.cn,1433;Database=SNADemo;User ID=xxx;Password=xxxx;Trusted_Connection=False;Encrypt=True;Connection Timeout=30;

 

Status: Delivered
See more ideas labeled with:
3 Comments (3 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎05-21-2017 07:07 PM

Hi @wei,

 

As this issue is related to Mooncake, I would suggest you create a Mooncake support ticket here: https://www.azure.cn/support/contact/.

 

Best Regards,
Qiuyun Yu

Vicky_Song
Impactful Individual
Impactful Individual
‎05-21-2017 07:08 PM
Status changed to: Delivered
 
wei
Frequent Visitor
‎05-21-2017 11:19 PM

Same problem happened on global azure,please help take a look:

[ powerbi ] Found dataset!
[ powerbi ] Id: a9005571-ac65-4002-9af7-d023b8f20956
[ 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
Idea Statuses