refresh AAS tabular model synchronously using Synapse Analytics ?

Question

can you please help provide any pointers towards refresh AAS tabular model synchronously using Synapse Analytics ?

Answer 1

Hey,

Please refer to the Pipeline JSON template :

https://github.com/NandanHegde15/Azure-DataFactory-Generic-Pipelines/blob/main/Azure%20Analysis%20Service/ProcessAzureAS/Pipeline/PL_Cmn_ProcessCube%20(without%20Linked%20service%20and%20Datasets).json

This would trigger the AAS model refresh and check for the status till the end

Answer 2

I think you would typically use Azure Synapse as your data source, and then programmatically trigger a refresh operation on your AAS model. Here's a general guide on how to achieve this:

1. Data Source :

• Ensure that your AAS tabular model has Azure Synapse Analytics as its data source.
• Proper connection strings and credentials should be set up in AAS to connect to Synapse Analytics.

2. Use Azure Automation or Logic Apps:
   • You can set up Azure Automation with a runbook or use Azure Logic Apps to periodically or on-demand refresh your AAS model.
3. Azure Analysis Services REST API:
   • AAS provides a REST API that allows you to manage and refresh your models. You can use this API to synchronously refresh your tabular model.

      
           $resourceGroupName = "Your-Resource-Group"
      
           $serverName = "Your-AAS-Server-Name"
      
           $databaseName = "Your-AAS-Database-Name"
      
           $modelRefreshUrl = "https://management.azure.com/subscriptions/$subscriptionId/resourceGroups/$resourceGroupName/providers/Microsoft.AnalysisServices/servers/$serverName/databases/$databaseName/refreshes?api-version=2017-08-01-preview"
      
           
      
           # Use Azure AD token for authentication
      
           $token = (Get-AzAccessToken -ResourceUrl https://analysis.windows.net/powerbi/api).Token
      
           $headers = @{
      
             "Authorization" = "Bearer $token"
      
             "Content-Type" = "application/json"
      
           }
      
           
      
           $body = @{
      
             "type" = "Full"
      
           } | ConvertTo-Json
      
           
      
           # Invoke REST API to refresh model
      
           Invoke-RestMethod -Method Post -Uri $modelRefreshUrl -Headers $headers -Body $body
      
      ```