{"id":730,"date":"2020-11-28T16:08:34","date_gmt":"2020-11-28T14:08:34","guid":{"rendered":"http:\/\/www.flip-design.de\/?p=730"},"modified":"2020-11-30T19:52:40","modified_gmt":"2020-11-30T17:52:40","slug":"azure-runbooks-and-pausing-power-bi-a-skus","status":"publish","type":"post","link":"https:\/\/www.flip-design.de\/?p=730","title":{"rendered":"Azure Runbooks and pausing Power BI A-SKU’s"},"content":{"rendered":"\n

If you have A-SKU’s deployed on Azure to run Power BI Embedded Resources for your developers, it is good to save money at non-working times, when you pause your capacity. This also applies when you have an application which is only used on your business hours.<\/p>\n\n\n\n

So you can use Azure Automation to trigger a start and stop event on appreciated times..<\/p>\n\n\n\n

Okay, this is the ressource:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

When we want to implement a Azure Automation Runbook to automate to start\/stop the resource, we need an Azure Automation Account in our tenant:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Now we can create a runbooks (type: Power Shell)<\/p>\n\n\n\n

The Script documentation can be found here:
https:\/\/docs.microsoft.com\/en-us\/rest\/api\/power-bi-embedded\/capacities<\/a><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

If you have multiple subscription in your tenant, you must set the default subscription at your runbook with following command. Otherwise you will receive following error:
Select-AzureSubscription : The subscription name MVP doesn’t exist.<\/span><\/strong>

Code for selecting the default subscription:<\/p>\n\n\n\n

$connectionName = \"AzureRunAsConnection\"\ntry\n{\n# Get the connection \"AzureRunAsConnection \"\n$servicePrincipalConnection=Get-AutomationConnection -Name $connectionName\n\n \n\n\"Logging in to Azure...\"\nAdd-AzureRmAccount `\n-ServicePrincipal `\n-TenantId $servicePrincipalConnection.TenantId `\n-ApplicationId $servicePrincipalConnection.ApplicationId `\n-CertificateThumbprint $servicePrincipalConnection.CertificateThumbprint\n}\ncatch {\nif (!$servicePrincipalConnection)\n{\n$ErrorMessage = \"Connection $connectionName not found.\"\nthrow $ErrorMessage\n} else{\nWrite-Error -Message $_.Exception\nthrow $_.Exception\n}\n}<\/code><\/pre>\n\n\n\n
Okay, this command is for starting:
Resume-AzureRmPowerBIEmbeddedCapacity -Name \"pbiem001\" -ResourceGroupName \"PBI\" -PassThru<\/code><\/p>\n\n\n\n
This one is for stopping the resource:
Stop-AzureRmPowerBIEmbeddedCapacity -Name \"pbiem001\" -ResourceGroupName \"PBI\" -PassThru<\/code><\/p>\n\n\n\n
Now you can add schedules to every runbook to trigger the code to your appreciated time to start or stop the ressource.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
That\u2019s it, now you can safe money 😊<\/p>\n","protected":false},"excerpt":{"rendered":"
If you have A-SKU’s deployed on Azure to run Power BI Embedded Resources for your developers, it is good to save money at non-working times, when you pause your capacity. This also applies when you have an application which is … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[1,30,27,41],"tags":[],"_links":{"self":[{"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts\/730"}],"collection":[{"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=730"}],"version-history":[{"count":3,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts\/730\/revisions"}],"predecessor-version":[{"id":737,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts\/730\/revisions\/737"}],"wp:attachment":[{"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=730"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=730"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=730"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}