Azure Analysis Services Reference
This section provides comprehensive reference information for Azure Analysis Services, covering its various components, APIs, and best practices.
APIs and SDKs
Explore the programmatic interfaces available for interacting with Azure Analysis Services. This includes REST APIs, .NET SDKs, and other client libraries.
REST API Reference
Detailed documentation for the Azure Analysis Services REST API, enabling you to manage and query your Analysis Services models programmatically.
.NET SDK
Learn how to use the .NET SDK to build applications that interact with Azure Analysis Services, including creating, deploying, and managing models.
Languages and Querying
Understand the languages used to define and query data within Azure Analysis Services.
Multidimensional Expressions (MDX)
MDX is a query language for OLAP cubes. Learn its syntax and capabilities for data retrieval and analysis.
Data Analysis Expressions (DAX)
DAX is a formula expression language used in Power BI, Analysis Services, and Power Pivot in Excel. It's essential for creating calculated columns and measures.
Tabular Model Metadata
Reference for the metadata objects that define a tabular model in Azure Analysis Services.
| Object Type | Description | Key Properties |
|---|---|---|
| Table | Represents a data table within the model. | Name, Columns, Measures, Relationships |
| Column | Represents a column within a table. | Name, DataType, IsKey, IsCalculated |
| Measure | A calculation defined using DAX. | Name, Expression, FormatString |
| Relationship | Defines a connection between two tables. | FromTable, FromColumn, ToTable, ToColumn, ReferentialIntegrity |
| Perspective | A subset of tables and columns for a specific user view. | Name, Tables |
| Role | Defines security permissions for users. | Name, Members, Read, Write |
Best Practices and Guidelines
Discover recommended practices for performance, scalability, and manageability of your Azure Analysis Services solutions.