Home / Azure / Analysis Services / Documentation / Deployment

Deploying Azure Analysis Services

This document provides comprehensive guidance on deploying Azure Analysis Services (AAS) effectively within your organization. It covers best practices for provisioning, configuration, and integration with your existing data infrastructure.

Provisioning an Azure Analysis Services Instance

You can provision an Azure Analysis Services instance through the Azure portal, Azure CLI, or PowerShell.

Using the Azure Portal

  1. Navigate to the Azure portal and search for "Azure Analysis Services".
  2. Click "Create" to start the provisioning process.
  3. Configure the following settings:
    • Subscription: Select your Azure subscription.
    • Resource group: Choose an existing or create a new resource group.
    • Server name: Provide a unique name for your server.
    • Location: Select the Azure region closest to your users or data sources.
    • Pricing tier: Choose a tier based on your performance and capacity needs (e.g., Developer, Basic, Standard).
    • Scale: Select the desired number of Analysis Services Engine (ASE) units.
  4. Review the settings and click "Create".

Using Azure CLI

az aas create --location "West US" --name "my-aas-server" --resource-group "my-resource-group" --sku "S0"

Configuring Your Analysis Services Server

Once provisioned, you can configure various aspects of your AAS server.

Firewall Settings

To secure your instance, configure firewall rules to restrict access to authorized IP addresses or virtual networks.

  • In the Azure portal, navigate to your Analysis Services resource.
  • Under "Settings", select "Firewall".
  • Enable the firewall and add allowed IP address ranges or virtual network rules.

Server Properties

You can customize server properties such as query timeout, memory allocation, and data source credentials.

Note: For detailed information on server properties and their impact, refer to the official Azure Analysis Services documentation.

Integrating with Data Sources

Azure Analysis Services connects to various on-premises and cloud data sources. Ensure proper connectivity and authentication are established.

On-Premises Data Gateway

For connecting to on-premises data sources, you must install and configure an On-premises Data Gateway.

  1. Download and install the gateway software on a machine that can access your data sources.
  2. Configure the gateway in the Azure portal, linking it to your AAS instance.

Cloud Data Sources

Connecting to cloud data sources like Azure SQL Database or Azure Data Lake Storage is generally more straightforward, often requiring only connection strings and credentials.

Deployment Strategies

Consider these strategies for deploying your Analysis Services models:

Azure DevOps Pipelines

Automate the deployment of your Analysis Services models using Azure DevOps. You can build and deploy models as part of your CI/CD pipeline.

Visual Studio with SQL Server Data Tools (SSDT)

Deploy your models directly from Visual Studio. SSDT provides tools for building, deploying, and managing Analysis Services projects.

Tabular Editor

Tabular Editor is a powerful third-party tool that provides advanced capabilities for managing and deploying tabular models. It's often used for scripting and automation.

Monitoring and Management

Regular monitoring is crucial for maintaining the health and performance of your AAS instance.

Azure Monitor

Utilize Azure Monitor to track key metrics, set up alerts, and diagnose issues. Monitor metrics such as CPU usage, memory, query performance, and connection counts.

Performance Tuning

Based on monitoring data, apply performance tuning techniques, including optimizing DAX queries, partitioning tables, and adjusting server resource allocation.

Tip: Regularly review your pricing tier and scale up or down as needed to optimize costs and performance.

Security Considerations

Implement robust security measures to protect your data.

  • Role-Based Access Control (RBAC): Assign appropriate roles to users and groups for managing the AAS server and its datasets.
  • Row-Level Security (RLS): Implement RLS to filter data dynamically based on the logged-in user.
  • Data Encryption: Azure Analysis Services encrypts data at rest and in transit by default.
Warning: Never embed sensitive credentials directly in model definitions. Use secure methods like Azure Key Vault or Managed Identities.

By following these guidelines, you can successfully deploy and manage Azure Analysis Services for your analytical needs.