Microsoft Azure

Create an Azure Analysis Services instance

This guide walks you through the steps to create a new Azure Analysis Services instance using the Azure portal.

Prerequisites

Tip: You can also create an Azure Analysis Services instance using Azure CLI or Azure PowerShell.

Steps to create an instance

  1. Sign in to the Azure portal.

    Open your web browser and go to https://portal.azure.com/. Sign in with your Azure account.

  2. Create a new resource.

    In the Azure portal, select + Create a resource from the top-left menu.

    Azure portal create resource button
  3. Search for Azure Analysis Services.

    In the Search the Marketplace box, type Azure Analysis Services and then select it from the search results.

  4. Click Create.

    On the Azure Analysis Services page, click the Create button.

  5. Configure the basic settings.

    In the Basics tab, configure the following settings:

    • Subscription: Select your Azure subscription.
    • Resource group: Select an existing resource group or create a new one. A resource group is a logical container for your Azure resources.
    • Server name: Enter a unique name for your Analysis Services server. The name must be globally unique across Azure.
    • Location: Choose the Azure region where you want to deploy your server.
    • Select a pricing tier: Choose a pricing tier that meets your performance and cost requirements. You can upgrade or downgrade the tier later.
    Azure Analysis Services basics configuration
  6. Configure advanced settings (optional).

    You can optionally configure advanced settings such as:

    • Allow Azure AD admin to connect: Enable this to specify an Azure AD admin for the server.
    • Enable query scale out: Configure query scale out for improved query performance.
  7. Review and create.

    Once you have configured all the settings, click the Review + create button. Azure will validate your settings.

  8. Create the instance.

    After validation passes, click the Create button to start the deployment of your Azure Analysis Services instance.

    The deployment process may take a few minutes. You will receive a notification when the deployment is complete.

After creation

Once your Azure Analysis Services instance is deployed, you can connect to it using tools like SQL Server Data Tools (SSDT), SQL Server Management Studio (SSMS), or Power BI.

Note: Ensure you have the necessary permissions in your Azure Active Directory (Azure AD) to manage Azure Analysis Services resources.

Next Steps