Error while Creating PowerBI workspace in azure through CLI

[ddarshan]

Hi All,

I am trying to create a PowerBI workspace using Azure CLI using below link:

http://blog.jongallant.com/2017/01/create-powerbi-embedded-workspace-collection-with-azure-cli-1-0/ 

it is failing for this command: azure powerbi create powerbi-rg2 PowerBITest westus

Error below:

2017-07-11T15:48:31.146Z:
{ Error
<<< async stack >>>
at __1 (C:\Users\darshad\AppData\Roaming\npm\node_modules\azure-cli\lib\commands\arm\powerbiembedded\powerbiembedded.js:88:59)
<<< raw stack >>>
at C:\Users\darshad\AppData\Roaming\npm\node_modules\azure-cli\node_modules\azure-arm-powerbiembedded\lib\operations\workspaceCollections.js:309:19
at retryCallback (C:\Users\darshad\AppData\Roaming\npm\node_modules\azure-cli\node_modules\ms-rest\lib\filters\systemErrorRetryPolicyFilter.js:85:9)
at retryCallback (C:\Users\darshad\AppData\Roaming\npm\node_modules\azure-cli\node_modules\ms-rest\lib\filters\exponentialRetryPolicyFilter.js:135:9)
at handleRedirect (C:\Users\darshad\AppData\Roaming\npm\node_modules\azure-cli\node_modules\ms-rest\lib\filters\redirectFilter.js:36:9)
at C:\Users\darshad\AppData\Roaming\npm\node_modules\azure-cli\lib\util\utils.js:608:7
at handleRedirect (C:\Users\darshad\AppData\Roaming\npm\node_modules\azure-cli\lib\util\utils.js:585:9)
at C:\Users\darshad\AppData\Roaming\npm\node_modules\azure-cli\lib\util\logging.js:331:7
at Request._callback (C:\Users\darshad\AppData\Roaming\npm\node_modules\azure-cli\node_modules\ms-rest\lib\requestPipeline.js:126:16)
at Request.self.callback (C:\Users\darshad\AppData\Roaming\npm\node_modules\azure-cli\node_modules\request\request.js:187:22)
at emitTwo (events.js:106:13)
stack: [Getter/Setter],
statusCode: 409,
request:
{ rawResponse: false,
queryString: {},
url: 'https://management.azure.com/subscriptions/65eb828e-8e01-4a64-b8ad-65d0440c2079/resourceGroups/power...',
method: 'PUT',
headers:
{ 'x-ms-client-request-id': '4fe5e2c5-ffc7-4c6b-b7eb-20a1c8740b43',
'accept-language': 'en-US',
'Content-Type': 'application/json; charset=utf-8',
'x-ms-command-name': 'powerbi create',
'x-ms-parameter-set-name': '*********** ************* ******',
'user-agent': 'AzureXplatCLI/0.10.14;osType:Windows_NT;osVersion:10.0.15063;nodeVersion:v6.10.2;installationType:NPM;userType:user;macAddressHash:cd87d6c980a4a5a6b10404976880831e0cd421854833dadc5d1c94bb387449a5' },
body: '{"location":"westus","tags":{},"sku":{"name":"S1","tier":"Standard"}}' },
response:
{ body: '',
headers:
{ 'cache-control': 'no-store, must-revalidate, no-cache',
'content-length': '0',
'content-type': 'application/octet-stream',
'x-ms-ratelimit-remaining-subscription-writes': '1199',
'strict-transport-security': 'max-age=31536000; includeSubDomains',
'x-frame-options': 'deny',
'x-content-type-options': 'nosniff',
requestid: '962d56bb-ce6d-4617-a5da-aade604189e9',
'x-ms-request-id': '962d56bb-ce6d-4617-a5da-aade604189e9',
server: 'Microsoft-HTTPAPI/2.0',
'x-ms-correlation-request-id': '4ff12d65-a5d8-44c6-8fc3-8c2b55b15c73',
'x-ms-routing-request-id': 'SOUTHEASTASIA:20170711T154948Z:4ff12d65-a5d8-44c6-8fc3-8c2b55b15c73',
date: 'Tue, 11 Jul 2017 15:49:48 GMT',
connection: 'close' },
statusCode: 409 },
__frame:
{ name: '__1',
line: 53,
file: 'C:\\Users\\darshad\\AppData\\Roaming\\npm\\node_modules\\azure-cli\\lib\\commands\\arm\\powerbiembedded\\powerbiembedded.js',
prev: undefined,
calls: 0,
active: false,
offset: 35,
col: 58 },
rawStack: [Getter] }
Error
<<< async stack >>>
at __1 (C:\Users\darshad\AppData\Roaming\npm\node_modules\azure-cli\lib\commands\arm\powerbiembedded\powerbiembedded.js:88:59)
<<< raw stack >>>
at C:\Users\darshad\AppData\Roaming\npm\node_modules\azure-cli\node_modules\azure-arm-powerbiembedded\lib\operations\workspaceCollections.js:309:19
at retryCallback (C:\Users\darshad\AppData\Roaming\npm\node_modules\azure-cli\node_modules\ms-rest\lib\filters\systemErrorRetryPolicyFilter.js:85:9)
at retryCallback (C:\Users\darshad\AppData\Roaming\npm\node_modules\azure-cli\node_modules\ms-rest\lib\filters\exponentialRetryPolicyFilter.js:135:9)
at handleRedirect (C:\Users\darshad\AppData\Roaming\npm\node_modules\azure-cli\node_modules\ms-rest\lib\filters\redirectFilter.js:36:9)
at C:\Users\darshad\AppData\Roaming\npm\node_modules\azure-cli\lib\util\utils.js:608:7
at handleRedirect (C:\Users\darshad\AppData\Roaming\npm\node_modules\azure-cli\lib\util\utils.js:585:9)
at C:\Users\darshad\AppData\Roaming\npm\node_modules\azure-cli\lib\util\logging.js:331:7
at Request._callback (C:\Users\darshad\AppData\Roaming\npm\node_modules\azure-cli\node_modules\ms-rest\lib\requestPipeline.js:126:16)
at Request.self.callback (C:\Users\darshad\AppData\Roaming\npm\node_modules\azure-cli\node_modules\request\request.js:187:22)
at emitTwo (events.js:106:13)

any help is appreciated.

Thanks,

Dhruva

[ddarshan]

Hi All,

I am trying to creating PowerBI workspace in azure through CLI using below link:

http://blog.jongallant.com/2017/01/create-powerbi-embedded-workspace-collection-with-azure-cli-1-0/

following command: azure powerbi create powerbi-rg2 PowerBITest westus is failing, error below:

2017-07-11T15:48:31.146Z:
{ Error
<<< async stack >>>
at __1 (C:\Users\darshad\AppData\Roaming\npm\node_modules\azure-cli\lib\commands\arm\powerbiembedded\powerbiembedded.js:88:59)
<<< raw stack >>>
at C:\Users\darshad\AppData\Roaming\npm\node_modules\azure-cli\node_modules\azure-arm-powerbiembedded\lib\operations\workspaceCollections.js:309:19
at retryCallback (C:\Users\darshad\AppData\Roaming\npm\node_modules\azure-cli\node_modules\ms-rest\lib\filters\systemErrorRetryPolicyFilter.js:85:9)
at retryCallback (C:\Users\darshad\AppData\Roaming\npm\node_modules\azure-cli\node_modules\ms-rest\lib\filters\exponentialRetryPolicyFilter.js:135:9)
at handleRedirect (C:\Users\darshad\AppData\Roaming\npm\node_modules\azure-cli\node_modules\ms-rest\lib\filters\redirectFilter.js:36:9)
at C:\Users\darshad\AppData\Roaming\npm\node_modules\azure-cli\lib\util\utils.js:608:7
at handleRedirect (C:\Users\darshad\AppData\Roaming\npm\node_modules\azure-cli\lib\util\utils.js:585:9)
at C:\Users\darshad\AppData\Roaming\npm\node_modules\azure-cli\lib\util\logging.js:331:7
at Request._callback (C:\Users\darshad\AppData\Roaming\npm\node_modules\azure-cli\node_modules\ms-rest\lib\requestPipeline.js:126:16)
at Request.self.callback (C:\Users\darshad\AppData\Roaming\npm\node_modules\azure-cli\node_modules\request\request.js:187:22)
at emitTwo (events.js:106:13)
stack: [Getter/Setter],
statusCode: 409,
request:
{ rawResponse: false,
queryString: {},
url: 'https://management.azure.com/subscriptions/65eb828e-8e01-4a64-b8ad-65d0440c2079/resourceGroups/power...',
method: 'PUT',
headers:
{ 'x-ms-client-request-id': '4fe5e2c5-ffc7-4c6b-b7eb-20a1c8740b43',
'accept-language': 'en-US',
'Content-Type': 'application/json; charset=utf-8',
'x-ms-command-name': 'powerbi create',
'x-ms-parameter-set-name': '*********** ************* ******',
'user-agent': 'AzureXplatCLI/0.10.14;osType:Windows_NT;osVersion:10.0.15063;nodeVersion:v6.10.2;installationType:NPM;userType:user;macAddressHash:cd87d6c980a4a5a6b10404976880831e0cd421854833dadc5d1c94bb387449a5' },
body: '{"location":"westus","tags":{},"sku":{"name":"S1","tier":"Standard"}}' },
response:
{ body: '',
headers:
{ 'cache-control': 'no-store, must-revalidate, no-cache',
'content-length': '0',
'content-type': 'application/octet-stream',
'x-ms-ratelimit-remaining-subscription-writes': '1199',
'strict-transport-security': 'max-age=31536000; includeSubDomains',
'x-frame-options': 'deny',
'x-content-type-options': 'nosniff',
requestid: '962d56bb-ce6d-4617-a5da-aade604189e9',
'x-ms-request-id': '962d56bb-ce6d-4617-a5da-aade604189e9',
server: 'Microsoft-HTTPAPI/2.0',
'x-ms-correlation-request-id': '4ff12d65-a5d8-44c6-8fc3-8c2b55b15c73',
'x-ms-routing-request-id': 'SOUTHEASTASIA:20170711T154948Z:4ff12d65-a5d8-44c6-8fc3-8c2b55b15c73',
date: 'Tue, 11 Jul 2017 15:49:48 GMT',
connection: 'close' },
statusCode: 409 },
__frame:
{ name: '__1',
line: 53,
file: 'C:\\Users\\darshad\\AppData\\Roaming\\npm\\node_modules\\azure-cli\\lib\\commands\\arm\\powerbiembedded\\powerbiembedded.js',
prev: undefined,
calls: 0,
active: false,
offset: 35,
col: 58 },
rawStack: [Getter] }
Error
<<< async stack >>>
at __1 (C:\Users\darshad\AppData\Roaming\npm\node_modules\azure-cli\lib\commands\arm\powerbiembedded\powerbiembedded.js:88:59)
<<< raw stack >>>
at C:\Users\darshad\AppData\Roaming\npm\node_modules\azure-cli\node_modules\azure-arm-powerbiembedded\lib\operations\workspaceCollections.js:309:19
at retryCallback (C:\Users\darshad\AppData\Roaming\npm\node_modules\azure-cli\node_modules\ms-rest\lib\filters\systemErrorRetryPolicyFilter.js:85:9)
at retryCallback (C:\Users\darshad\AppData\Roaming\npm\node_modules\azure-cli\node_modules\ms-rest\lib\filters\exponentialRetryPolicyFilter.js:135:9)
at handleRedirect (C:\Users\darshad\AppData\Roaming\npm\node_modules\azure-cli\node_modules\ms-rest\lib\filters\redirectFilter.js:36:9)
at C:\Users\darshad\AppData\Roaming\npm\node_modules\azure-cli\lib\util\utils.js:608:7
at handleRedirect (C:\Users\darshad\AppData\Roaming\npm\node_modules\azure-cli\lib\util\utils.js:585:9)
at C:\Users\darshad\AppData\Roaming\npm\node_modules\azure-cli\lib\util\logging.js:331:7
at Request._callback (C:\Users\darshad\AppData\Roaming\npm\node_modules\azure-cli\node_modules\ms-rest\lib\requestPipeline.js:126:16)
at Request.self.callback (C:\Users\darshad\AppData\Roaming\npm\node_modules\azure-cli\node_modules\request\request.js:187:22)
at emitTwo (events.js:106:13)

Any help will be appreciated.

Thanks,

Dhruva

[Eric_Zhang · Accepted solution]

@ddarshan

I can create a workspace collection.

The problem in your case is that PBI Embedded workspace name "powerbi-test1" is not valid, try a name "powerbi-test011".

By the way, Power BI Embedded is being deprecated and it is not avaiable for new users. That's why you can't see the create option in Azure portal. Though you can bypass that creation lock by using the CLI, however you should note that the being deprecated Power BI Embedded will continue to work for a limited time, to avoid any extra migrating and re-developing work in future, it is recommended to start with the new replacement Embedding with non-Power BI users(Power BI Premium license needed).

[ddarshan]

 Thanks a lot Eric, that did the trick.

[Eric_Zhang]

Glad to hear it did the trick, if you have no further question, could you please accept the reply as solution to close this thread?