Create an Azure Analysis Services server
This article guides you through the process of creating an Azure Analysis Services server using the Azure portal, PowerShell, or Azure CLI.
Prerequisites
- An Azure subscription. If you don't have one, create a free account before you begin.
- Permissions to create resources in your Azure subscription.
Option 1: Create an Analysis Services server using the Azure portal
The Azure portal provides an intuitive graphical interface for creating and managing Azure resources.
Sign in to the Azure portal.
In the Azure portal, click Create a resource.

In the search bar, type Analysis Services, and then select it from the list.

Click Create.

In the Basics tab, configure the following settings:
- Subscription: Select your Azure subscription.
- Resource group: Create a new resource group or select an existing one.
- Server name: Enter a unique name for your server.
- Location: Choose the Azure region where you want to deploy your server.
- Pricing tier: Select a pricing tier based on your performance and scalability needs.

Click Review + create, and then click Create.

Option 2: Create an Analysis Services server using Azure PowerShell
Use Azure PowerShell to automate the creation of your Analysis Services server.
Install and connect to Azure PowerShell
If you don't have Azure PowerShell installed, follow the instructions in Install Azure PowerShell.
Connect to your Azure account:
Connect-AzAccount
Create the resource group (if needed)
New-AzResourceGroup -Name "YourResourceGroupName" -Location "East US"
Create the Analysis Services server
New-AzAnalysisServicesServer -Name "YourServerName" -ResourceGroupName "YourResourceGroupName" -Location "East US" -SkuName "S0" -Capacity 1
Replace "YourServerName"
, "YourResourceGroupName"
, "East US"
, and "S0"
with your desired values.
Option 3: Create an Analysis Services server using Azure CLI
Use Azure Command-Line Interface (CLI) for command-line automation.
Install and log in to Azure CLI
If you don't have Azure CLI installed, follow the instructions in Install the Azure CLI.
Log in to your Azure account:
az login
Create the resource group (if needed)
az group create --name YourResourceGroupName --location "East US"
Create the Analysis Services server
az analysiservices server create --name YourServerName --resource-group YourResourceGroupName --location "East US" --sku S0 --capacity 1
Replace YourServerName
, YourResourceGroupName
, "East US"
, and S0
with your desired values.
Get-AzAnalysisServicesSku
(PowerShell) or az analysiservices list-skus
(CLI).
Next Steps
Once your Analysis Services server is created, you can:
- Connect to your server using tools like SQL Server Management Studio (SSMS) or Visual Studio.
- Create a semantic model for your data.
- Manage your server settings, scale capacity, and configure security.