- Fix
- Feature
- Big feature
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# install module | |
Install-Module AzureAD -Scope CurrentUser # if already installed you can skip this line | |
Import-Module AzureAD # if already imported you can skip this line | |
# connect | |
Connect-AzureAD # this will initiate a dialog to enter credentials | |
# Find the SkuID of the license we want to add - in this case the Power BI Free license, which is called "POWER_BI_STANDARD" | |
$PowerBIFreeSKUId = Get-AzureADSubscribedSku | Where-Object {$_.SkuPartNumber -eq "POWER_BI_STANDARD"} | Select -ExpandProperty SkuId |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<# | |
.SYNOPSIS | |
Vertically scale up and down or pause/resume an Azure Power BI Embedded Capacity according to a schedule using Azure Automation. | |
.DESCRIPTION | |
This Azure Automation runbook enables vertically scaling or pausing of an Azure Power BI Embedded Capacity according to a schedule. Autoscaling based on a schedule allows you to scale your solution according to predictable resource demand. For example you could require a high capacity (e.g. A5) on monday during peak hours, while the rest of the week the traffic is decreased, allowing you to scale down (e.g. A1). Outside business hours and during weekends you could then suspend the capacity so no charges will be applied. This runbook can be scheduled to run hourly. The code checks the scalingSchedule parameter to decide if scaling needs to be executed, or if the capacity is in the desired state already and no work needs to be done. The script is time zone aware. | |
.PARAMETER resourceGroupName | |
Name of the resource group to which the |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<# | |
.SYNOPSIS | |
Resume an Azure Power BI Embedded Capacity using Azure Automation. | |
.DESCRIPTION | |
This Azure Automation runbook enables resuming of an Azure Power BI Embedded Capacity. | |
.PARAMETER resourceGroupName | |
Name of the resource group to which the capacity is assigned. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<# | |
.SYNOPSIS | |
Pause/suspend an Azure Power BI Embedded Capacity using Azure Automation. | |
.DESCRIPTION | |
This Azure Automation runbook enables pausing/suspending of an Azure Power BI Embedded Capacity. | |
.PARAMETER resourceGroupName | |
Name of the resource group to which the capacity is assigned. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"name": "ADF_Scale_Azure_AS", | |
"properties": { | |
"activities": [ | |
{ | |
"name": "00_Scale_Azure_AS", | |
"type": "WebActivity", | |
"policy": { | |
"timeout": "7.00:00:00", | |
"retry": 0, |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"name": "ADF_Scale_Azure_SQLDB", | |
"properties": { | |
"activities": [ | |
{ | |
"name": "ADF_Scale_Azure_SQLDB", | |
"type": "WebActivity", | |
"policy": { | |
"timeout": "7.00:00:00", | |
"retry": 0, |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"name": "pipeline1", | |
"properties": { | |
"activities": [ | |
{ | |
"name": "Call dataset refresh", | |
"type": "WebActivity", | |
"dependsOn": [ | |
{ | |
"activity": "Get AAD Token", |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# ================================================================================================================================================= | |
## This script will add the given Service Principal to Power BI workspaces | |
## It will first ask for the (correct) ObjectId of the Service Principal | |
## Then it will ask for the credentials of a Power BI Service Administrator | |
## Note: this script only works with v2 workspaces (you can't add a Service Principal to a v1 workspace) | |
# ================================================================================================================================================= | |
## Parameters |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# ================================================================================================================================================= | |
## This script will remove the given Service Principal from Power BI workspaces | |
## It will first ask for the (correct) ObjectId of the Service Principal | |
## Then it will ask for the credentials of a Power BI Service Administrator | |
# ================================================================================================================================================= | |
## Parameters | |
# Remove the Service Principal from workspaces that are in Premium capacity? | |
$RemoveFromPremiumCapacityWorkspaces = $true |
OlderNewer