Skip to main content

power_bi_resources

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

Overview

Namepower_bi_resources
TypeResource
Idazure.powerbi_privatelinks.power_bi_resources

Fields

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

Methods

NameAccessible byRequired ParamsDescription
createINSERTazureResourceName, resourceGroupName, subscriptionIdCreates or updates a Private Link Service Resource for Power BI.
deleteDELETEazureResourceName, resourceGroupName, subscriptionIdDeletes a Private Link Service Resource for Power BI.
updateUPDATEazureResourceName, resourceGroupName, subscriptionIdCreates or updates a Private Link Service Resource for Power BI.
list_by_resource_nameEXECazureResourceName, resourceGroupName, subscriptionIdGets all the private link resources for the given Azure resource.

INSERT example

Use the following StackQL query and manifest file to create a new power_bi_resources resource.

/*+ create */
INSERT INTO azure.powerbi_privatelinks.power_bi_resources (
azureResourceName,
resourceGroupName,
subscriptionId,
location,
properties,
tags
)
SELECT
'{{ azureResourceName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ location }}',
'{{ properties }}',
'{{ tags }}'
;

UPDATE example

Updates a power_bi_resources resource.

/*+ update */
UPDATE azure.powerbi_privatelinks.power_bi_resources
SET
location = '{{ location }}',
properties = '{{ properties }}',
tags = '{{ tags }}'
WHERE
azureResourceName = '{{ azureResourceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified power_bi_resources resource.

/*+ delete */
DELETE FROM azure.powerbi_privatelinks.power_bi_resources
WHERE azureResourceName = '{{ azureResourceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';