Azure Analysis Services Reference

Overview

Azure Analysis Services (AAS) is a fully managed cloud data platform that provides enterprise-grade data modeling capabilities. It enables you to build semantic models (tabular and multidimensional) that aggregate and process data from various sources, providing a single source of truth for business intelligence and analytics.

Key features include:

Scalability: Easily scale your analysis services to meet growing data demands.
Performance: Leverage in-memory caching and query optimization for lightning-fast insights.
Integration: Seamlessly integrates with Power BI, Excel, and other BI tools.
Security: Robust security features to protect your sensitive data.
High Availability: Built-in resilience and disaster recovery options.

REST API Reference

The Azure Analysis Services REST API allows you to programmatically manage your Analysis Services resources. This includes creating, deleting, querying, and updating your Analysis Services servers and databases.

Base URL

https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.AnalysisServices/servers/{resourceName}?api-version=2017-08-01

Common Operations

GET Server Details

GET /servers/{resourceName} Retrieves the details of an Analysis Services server.

Responses:

200 OK - Successful retrieval of server details.

404 Not Found - The specified server does not exist.

CREATE or UPDATE Server

PUT /servers/{resourceName} Creates or updates an Analysis Services server.

Parameters:

resourceName (path, required): The name of the Analysis Services server.

api-version (query, required): The API version.

parameters (body, required): The server properties.

Responses:

201 Created - Server created successfully.

200 OK - Server updated successfully.

400 Bad Request - Invalid request payload.

DELETE Server

DELETE /servers/{resourceName} Deletes an Analysis Services server.

Responses:

204 No Content - Server deleted successfully.

404 Not Found - The specified server does not exist.

Resource Types

Resource Type	Description	API Endpoint
Servers	Represents an Azure Analysis Services instance.	`/providers/Microsoft.AnalysisServices/servers`
Databases	Represents an Analysis Services database within a server.	`/servers/{resourceName}/databases`
Firewall Rules	Manages firewall access rules for an Analysis Services server.	`/servers/{resourceName}/firewallRules`
Gateway Connections	Manages connections to on-premises data sources via gateways.	`/servers/{resourceName}/gatewayConnections`

Quick Start Tutorials

Frequently Asked Questions

What is the difference between Azure Analysis Services and SQL Server Analysis Services?

Azure Analysis Services is a cloud-based, fully managed SaaS offering, while SQL Server Analysis Services is an on-premises installation. AAS offers scalability, high availability, and integration with Azure services.

How do I connect to an Azure Analysis Services server?

You can connect using tools like SQL Server Management Studio (SSMS), Visual Studio, or directly from BI tools like Power BI and Excel. Connection strings typically include the server name and authentication details.

What are the pricing tiers for Azure Analysis Services?

Azure Analysis Services offers various tiers (Developer, Basic, Standard) with different performance and scalability options to suit your needs. Refer to the official Azure pricing page for the latest details.