Skip to main content

workspace_collections

Creates, updates, deletes, gets or lists a workspace_collections resource.

Overview

Nameworkspace_collections
TypeResource
Idazure.powerbi_embedded.workspace_collections

Fields

The following fields are returned by SELECT queries:

SELECT not supported for this resource, use SHOW METHODS to view available operations for the resource.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
createinsertsubscriptionId, resourceGroupName, workspaceCollectionNameCreates a new Power BI Workspace Collection with the specified properties. A Power BI Workspace Collection contains one or more workspaces, and can be used to provision keys that provide API access to those workspaces.
updateupdatesubscriptionId, resourceGroupName, workspaceCollectionNameUpdate an existing Power BI Workspace Collection with the specified properties.
deletedeletesubscriptionId, resourceGroupName, workspaceCollectionNameDelete a Power BI Workspace Collection.
check_name_availabilityexecsubscriptionId, locationVerify the specified Power BI Workspace Collection name is valid and not already in use.
regenerate_keyexecsubscriptionId, resourceGroupName, workspaceCollectionNameRegenerates the primary or secondary access key for the specified Power BI Workspace Collection.
migrateexecsubscriptionId, resourceGroupNameMigrates an existing Power BI Workspace Collection to a different resource group and/or subscription.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
locationstringAzure location
resourceGroupNamestringAzure resource group
subscriptionIdstringGets subscription credentials which uniquely identify a Microsoft Azure subscription. The subscription ID forms part of the URI for every service call.
workspaceCollectionNamestringPower BI Embedded Workspace Collection name

INSERT examples

Creates a new Power BI Workspace Collection with the specified properties. A Power BI Workspace Collection contains one or more workspaces, and can be used to provision keys that provide API access to those workspaces.

INSERT INTO azure.powerbi_embedded.workspace_collections (
data__location,
data__tags,
data__sku,
subscriptionId,
resourceGroupName,
workspaceCollectionName
)
SELECT
'{{ location }}',
'{{ tags }}',
'{{ sku }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ workspaceCollectionName }}'
RETURNING
id,
name,
location,
properties,
sku,
tags,
type
;

UPDATE examples

Update an existing Power BI Workspace Collection with the specified properties.

UPDATE azure.powerbi_embedded.workspace_collections
SET
data__tags = '{{ tags }}',
data__sku = '{{ sku }}'
WHERE
subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND workspaceCollectionName = '{{ workspaceCollectionName }}' --required
RETURNING
id,
name,
location,
properties,
sku,
tags,
type;

DELETE examples

Delete a Power BI Workspace Collection.

DELETE FROM azure.powerbi_embedded.workspace_collections
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND workspaceCollectionName = '{{ workspaceCollectionName }}' --required
;

Lifecycle Methods

Verify the specified Power BI Workspace Collection name is valid and not already in use.

EXEC azure.powerbi_embedded.workspace_collections.check_name_availability 
@subscriptionId='{{ subscriptionId }}' --required,
@location='{{ location }}' --required
@@json=
'{
"name": "{{ name }}",
"type": "{{ type }}"
}'
;