Use PowerShell to Enable and Automate Azure Analysis Services Backup

Param
(
    [Parameter(Mandatory = $true)][string]$resourceGroupName,
    [Parameter(Mandatory = $true)][string]$analysisServicesName,
    [Parameter(Mandatory = $true)][string]$storageAccountName,
    [Parameter(Mandatory = $true)][string]$containerName)

function Add-AnalysisServicesBackupBlobContainer($props, $resourceGroupName, $storageAccountName, $containerName) {
    # Get storage account keys.
    $keys = Get-AzureRmStorageAccountKey `
        -StorageAccountName $storageAccountName `
        -ResourceGroupName $resourceGroupName

    # Use first key.
    $key = $keys[0].Value

    # Create an Azure Storage Context for the storage account.
    $context = New-AzureStorageContext -StorageAccountName $storageAccountName -StorageAccountKey $key

    # Create a 2 Years SAS Token
    $starTime = (Get-Date).AddMinutes(-5)
    $sasToken = New-AzureStorageContainerSASToken `
        -Name $containerName `
        -Context $context `
        -ExpiryTime $starTime.AddYears(2) `
        -Permission rwdlac `
        -Protocol HttpsOnly `
        -StartTime $starTime

    # Create the Container Uri
    $blobContainerUri = "https://$($storageAccountName).blob.core.windows.net/$($containerName)$($sasToken)"

    # Check the Analysis Server to see if the backupBlobContainerUri property exists.
    $backupBlobContainerUriProperty = $props | Get-Member -Name "backupBlobContainerUri"
    if (!$backupBlobContainerUriProperty) {
        # Add the property to the object.
        $props | Add-Member @{backupBlobContainerUri = ""}
    }

    # Set the container Uri
    $props.backupBlobContainerUri = $blobContainerUri
}

# Get the Analysis Services resource properties.
$resource = Get-AzureRmResource `
    -ResourceGroupName $resourceGroupName `
    -ResourceType "Microsoft.AnalysisServices/servers" `
    -ResourceName $analysisServicesName

$props = $resource.Properties

# Modify the backupBlobContainerUri.
Add-AnalysisServicesBackupBlobContainer $props $resourceGroupName $storageAccountName $containerName

# Save the properties.
Set-AzureRmResource `
    -PropertyObject $props `
    -ResourceGroupName $resourceGroupName `
    -ResourceType "Microsoft.AnalysisServices/servers" `
    -ResourceName $analysisServicesName `
    -Force

<#
    .SYNOPSIS
        Backup-AnalysisServices is a simple PowerShell workflow runbook that will help you automate the process of backing up an Azure Analysis Service Database.

    .DESCRIPTION
        Backup-AnalysisServices is a simple PowerShell workflow runbook that will help you automate the process of backing up an Azure Analysis Service Database.

    .PARAMETER ResourceGroupName
        The name of the resource group where the cluster resides

    .PARAMETER AutomationCredentialName
        The Automation credential holding the username and password for Analysis Services

    .PARAMETER AnalysisServiceDatabase
        The Analysis Service Database

    .PARAMETER AnalysisServiceServer
        The Analysis Service Server

    .PARAMETER ConnectionName
        The name of your automation connection account. Defaults to  'AzureRunAsConnection'

    .NOTES
        AUTHOR: Carlos Mendible
        LASTEDIT: October 17, 2017
#>
workflow Backup-AnalysisServices {
    Param
    (
        [Parameter(Mandatory = $true)]
        [String]$ResourceGroupName,

        [Parameter(Mandatory = $true)]
        [String]$AutomationCredentialName,

        [Parameter(Mandatory = $true)]
        [String]$AnalysisServiceDatabase,

        [Parameter(Mandatory = $true)]
        [String]$AnalysisServiceServer,
        [Parameter(Mandatory = $false)]
        [String]$ConnectionName
    )

    # Requires the AzureRM.Profile and SqlServer PowerShell Modules

    $automationConnectionName = $ConnectionName
    if (!$ConnectionName) {
        $automationConnectionName = "AzureRunAsConnection"
    }

    # Get the connection by name (i.e. AzureRunAsConnection)
    $servicePrincipalConnection = Get-AutomationConnection -Name $automationConnectionName

    Write-Output "Logging in to Azure..."

    Add-AzureRmAccount `
        -ServicePrincipal `
        -TenantId $servicePrincipalConnection.TenantId `
        -ApplicationId $servicePrincipalConnection.ApplicationId `
        -CertificateThumbprint $servicePrincipalConnection.CertificateThumbprint

    # Get PSCredential
    $cred = Get-AutomationPSCredential -Name $AutomationCredentialName

    Write-Output "Starting Backup..."

    Backup-ASDatabase `
        –backupfile ("backup." + (Get-Date).ToString("yyMMdd") + ".abf") `
        –name $AnalysisServiceDatabase `
        -server $AnalysisServiceServer `
        -Credential $cred
}