Top / Microsoft Azure / Azure Analysis Services / Server

Azure Analysis Services Server

This page shows how to write Terraform and Azure Resource Manager for Analysis Services Server and write them securely.

terraform-logo

Review your .tf file for Azure best practices

Shisho Cloud, our free checker to make sure your Terraform configuration follows best practices, is available (beta).

azurerm_analysis_services_server (Terraform)

The Server in Analysis Services can be configured in Terraform with the resource name azurerm_analysis_services_server. The following sections describe 9 examples of how to use the resource and its parameters.

Example Usage from GitHub

main.tf#L1
resource "azurerm_analysis_services_server" "module" {
  name                    = var.analysis_name
  location                = var.analysis_location
  resource_group_name     = var.rg_name
  sku                     = var.analysis_sku
  admin_users             = var.analysis_admins
AnalysisService.tf#L2
resource "azurerm_analysis_services_server" "server" {
  name                    = var.analysis_service_name
  location                = data.azurerm_resource_group.rg.location
  resource_group_name     = data.azurerm_resource_group.rg.name
  sku                     = var.sku
  backup_blob_container_uri = var.backup_container_url
main.tf#L54
resource "azurerm_analysis_services_server" "server" {
  name                    = "analysisservicesserver"
  location                = azurerm_resource_group.tfimportarticle.location
  resource_group_name     = azurerm_resource_group.tfimportarticle.name
  sku                     = "S0"
  admin_users             = ["myuser@domain.tld"]
main.tf#L1
resource "azurerm_analysis_services_server" "default" {
  name                      = var.name
  location                  = var.location
  resource_group_name       = var.resource_group_name
  sku                       = var.sku
  admin_users               = var.admin_users
main.tf#L7
resource "azurerm_analysis_services_server" "this" {
  admin_users               = var.admin_users
  backup_blob_container_uri = var.backup_blob_container_uri
  enable_power_bi_service   = var.enable_power_bi_service
  location                  = var.location
  name                      = var.name
main.tf#L1
resource "azurerm_analysis_services_server" "analysis_services_server" {
  count                     = length(var.analysis_services_server)
  location                  = element(var.location, lookup(var.analysis_services_server[count.index], "location_id"))
  name                      = lookup(var.analysis_services_server[count.index], "name")
  resource_group_name       = element(var.resource_group_name, lookup(var.analysis_services_server[count.index], "resource_group_id"))
  sku                       = lookup(var.analysis_services_server[count.index], "sku")
main.tf#L15
resource "azurerm_analysis_services_server" "server" {
  name                    = var.analysis_services_server_full_name
  location                = var.location
  resource_group_name     = var.resource_group_name
  sku                     = var.analysis_services_server_sku
  admin_users             = var.analysis_services_server_admin_users
main.tf#L7
resource "azurerm_analysis_services_server" "this" {
  admin_users               = var.admin_users
  backup_blob_container_uri = var.backup_blob_container_uri
  enable_power_bi_service   = var.enable_power_bi_service
  location                  = var.location
  name                      = var.name
main.tf#L229
resource "azurerm_analysis_services_server" "serveranalisys" {
  name                    = "analysisservicesserver"
  location                = azurerm_resource_group.rg.location
  resource_group_name     = azurerm_resource_group.rg.name
  sku                     = "S0"
  enable_power_bi_service = true

Review your Terraform file for Azure best practices

Shisho Cloud, our free checker to make sure your Terraform configuration follows best practices, is available (beta).

Parameters

>> from Terraform Registry

Explanation in Terraform Registry

Manages an Analysis Services Server.

>> from Terraform Registry

Microsoft.AnalysisServices/servers (Azure Resource Manager)

The servers in Microsoft.AnalysisServices can be configured in Azure Resource Manager with the resource name Microsoft.AnalysisServices/servers. The following sections describe how to use the resource and its parameters.

Example Usage from GitHub

An example could not be found in GitHub.

Parameters

  • apiVersion required - string
  • location required - string

    Location of the Analysis Services resource.

  • name required - string

    The name of the Analysis Services server. It must be a minimum of 3 characters, and a maximum of 63.

  • properties required
      • asAdministrators optional
          • members optional - array

            An array of administrator user identities.

      • backupBlobContainerUri optional - string

        The SAS container URI to the backup container.

      • gatewayDetails optional
          • gatewayResourceId optional - string

            Gateway resource to be associated with the server.

      • ipV4FirewallSettings optional
          • enablePowerBIService optional - boolean

            The indicator of enabling PBI service.

          • firewallRules optional array
              • firewallRuleName optional - string

                The rule name.

              • rangeEnd optional - string

                The end range of IPv4.

              • rangeStart optional - string

                The start range of IPv4.

      • managedMode optional - integer

        The managed mode of the server (0 = not managed, 1 = managed).

      • querypoolConnectionMode optional - string

        How the read-write server's participation in the query pool is controlled.<br/>It can have the following values: <ul><li>readOnly - indicates that the read-write server is intended not to participate in query operations</li><li>all - indicates that the read-write server can participate in query operations</li></ul>Specifying readOnly when capacity is 1 results in error.

      • serverMonitorMode optional - integer

        The server monitor mode for AS server

      • sku optional
          • capacity optional - integer

            The number of instances in the read only query pool.

          • name required - string

            Name of the SKU level.

          • tier optional - string

            The name of the Azure pricing tier to which the SKU applies.

  • sku required
      • capacity optional - integer

        The number of instances in the read only query pool.

      • name required - string

        Name of the SKU level.

      • tier optional - string

        The name of the Azure pricing tier to which the SKU applies.

  • tags optional - string

    Key-value pairs of additional resource provisioning properties.

  • type required - string

>> from Azure Resource Manager Documentation

Frequently asked questions

What is Azure Analysis Services Server?

Azure Analysis Services Server is a resource for Analysis Services of Microsoft Azure. Settings can be wrote in Terraform.

Where can I find the example code for the Azure Analysis Services Server?

For Terraform, the jessewilk/terraform, chaitanya867/KPMG-a.txt and charotAmine/AzureCostEstimator-back source code examples are useful. See the Terraform Example section for further details.

security-icon

Automate config file reviews on your commits

Fix issues in your infrastructure as code with auto-generated patches.

Table of Contents