none
How to execute scheduled job for Azure Analysis Services RRS feed

All replies

  • Here are few articles that might help you in refreshing tabular model in Azure Analysis Services.

    1) Refresh with Azure Automation

    2)Refresh with Logic Apps

    Sunday, May 26, 2019 5:16 PM
    Moderator
  • Looking for Refresh with Azure Automation.

    Where I can find Refresh-Model-ps1 code?


    Kenny_I

    Sunday, May 26, 2019 8:06 PM
  • Here is sample code snippet for refreshing Azure Analysis Services using Powershell.

    param
    (
        [Parameter (Mandatory = $false)]
        [object] $WebhookData,
    
        [Parameter (Mandatory = $false)]
        [String] $DatabaseName,
        [Parameter (Mandatory = $false)]
        [String] $AnalysisServer,
        [Parameter (Mandatory = $false)]
        [String] $RefreshType
    )
    
    $_Credential = Get-AutomationPSCredential -Name "ServicePrincipal"
    
    # If runbook was called from Webhook, WebhookData will not be null.
    if ($WebhookData)
    { 
        # Retrieve AAS details from Webhook request body
        $atmParameters = (ConvertFrom-Json -InputObject $WebhookData.RequestBody)
        Write-Output "CredentialName: $($atmParameters.CredentialName)"
        Write-Output "AnalysisServicesDatabaseName: $($atmParameters.AnalysisServicesDatabaseName)"
        Write-Output "AnalysisServicesServer: $($atmParameters.AnalysisServicesServer)"
        Write-Output "DatabaseRefreshType: $($atmParameters.DatabaseRefreshType)"
        
        $_databaseName = $atmParameters.AnalysisServicesDatabaseName
        $_analysisServer = $atmParameters.AnalysisServicesServer
        $_refreshType = $atmParameters.DatabaseRefreshType
     
        Invoke-ProcessASDatabase -DatabaseName $_databaseName -RefreshType $_refreshType -Server $_analysisServer -ServicePrincipal -Credential $_credential
    }
    else 
    {
        Invoke-ProcessASDatabase -DatabaseName $DatabaseName -RefreshType $RefreshType -Server $AnalysisServer -ServicePrincipal -Credential $_Credential
    }

    Wednesday, May 29, 2019 4:26 AM
    Moderator
  • The "adventureworks" database does not exist on the server. I am facing with this issue
    • Edited by patil Varsha Wednesday, September 25, 2019 7:03 AM
    Wednesday, September 25, 2019 7:03 AM
  • The "adventureworks" database does not exist on the server.
    Wednesday, September 25, 2019 7:07 AM