Built on the proven analytics engine in Microsoft SQL Server Analysis Services, Azure Analysis Services provides enterprise-grade data modeling in the cloud.
Watch this video to learn more about how Azure Analysis Services fits in with Microsoft's overall BI capabilities and how you too can benefit from getting your semantic models into the cloud.
Azure Analysis Services is in preview. There are some things that just aren't working yet. Be sure to check out Preview expectations later in this article. And, be sure to keep an eye on our Azure Analysis Services blog for the latest info.
Built on SQL Server Analysis Services
Azure Analysis Services is compatible with the same SQL Server 2016 Analysis Services Enterprise Edition you already know. Azure Analysis Services supports tabular models at the 1200 compatibility level. DirectQuery, partitions, row-level security, bi-directional relationships, and translations are all supported.
Use the tools you already know
When creating data models for Azure Analysis Services, you use the same tools as for SQL Server Analysis Services. Author and deploy tabular models by using the latest versions of SQL Server Data Tools (SSDT) or by using Azure Powershell and Azure Resource Manager templates in SQL Server Management Studio (SSMS).
Connect to data sources
Data models deployed to servers in Azure support connecting to data sources on-premises in your organization or in the cloud. Combine data from both on-premises and cloud data sources for a hybrid BI solution.
Because your server is in the cloud, connecting to cloud data sources is seamless. When connecting to on-premises data sources, the On-premises data gateway ensures fast, secure connections with your Analysis Services server in the cloud.
* Some data sources are not yet supported in preview. To learn more, see Preview expectations later in this article.
Explore your data from anywhere
Connect and get data from your servers from about anywhere. Azure Analysis Services supports connecting from Power BI Desktop, Excel, custom apps, and browser-based tools.
* Power BI Embedded is not yet supported in preview.
User authentication for Azure Analysis services is handled by Azure Active Directory (AAD). When attempting to log in to an Azure Analysis Services database, users use an organization account identity with access to the database they are trying to access. These user identities must be members of the default Azure Active Directory for the subscription where the Azure Analysis Services server resides. Directory integration between AAD and an on-premises Active Directory is a great way to get your on-premises users access to an Azure Analysis Services database, but isn't required for all scenarios.
Users log in with the user principal name (UPN) of their account and their password. When synchronized with an on-premises Active Directory, the user’s UPN is often their organizational email address.
Permissions for managing the Azure Analysis Services server resource are handled by assigning users to roles within your Azure subscription. By default, subscription administrators have owner permissions to the server resource in Azure. Additional users can be added by using Azure Resource Manager.
Azure Analysis Services utilizes Azure Blob storage to persist storage and metadata for Analysis Services databases. Data files within Blob are encrypted using Azure Blob Server Side Encryption (SSE). When using Direct Query mode, only metadata is stored; the actual data is accessed from the data source at query time.
On-premises data sources
Secure access to data residing on-premises in your organization can be achieved by installing and configuring an On-premises data gateway. Gateways provide access to data for both Direct Query and in-memory modes. When an Azure Analysis Services model connects to an on-premises data source, a query is created along with the encrypted credentials for the on-premises data source. The gateway cloud service analyzes the query and pushes the request to an Azure Service Bus. The on-premises gateway polls the Azure Service Bus for pending requests. The gateway then gets the query, decrypts the credentials, and connects to the data source for execution. The results are then sent from the data source, back to the gateway and then on to the Azure Analysis Services database.
Azure Analysis Services is simple to set up and to manage. You can find all the info you need to create and manage a server here. When creating a data model to deploy to your server, it's much the same as it is for creating a data model you deploy to an on-premises server. There's an extensive library of conceptual, procedural, tutorials, and reference articles at Analysis Services on MSDN.
We also have a number of helpful videos at Azure Analysis Services on Channel 9.
Things are changing rapidly. You can always get the latest information on the Azure Analysis Services blog.
Analysis Services has a vibrant community of users. Join the conversation on Azure Analysis Services forum.
Have suggestions or feature requests? Be sure to leave your comments on Azure Analysis Services Feedback.
Have suggestions about the documentation? You can add comments using Disqus at the bottom of each article.
Azure Analysis Services is currently in preview. There are a few things you should be aware of.
Azure Analysis Services currently supports Tabular mode for tabular models at the 1200 compatibility level. Multidimensional and Data Mining mode, and Power Pivot for SharePoint mode are not supported.
For preview, the following data sources are supported in tabular 1200 models deployed to an Azure Analysis Services server.
|Cloud||On-premises (requires data gateway)|
|SQL database||SQL Server|
|SQL Data Warehouse||APS|
Data source providers
Data models in Azure Analysis Services may require different data providers to connect to data sources than data models in SQL Server Analysis Services. Data provider requirements depend on the data source being in the cloud or on-premises, and the type of data model; in-memory or Direct Query. To learn more, see Datasource connections.
Client applications require the latest client data providers to connect to Azure Analysis Services.
Excel workbooks with live connections to an Azure Analysis Services server and saved on OneDrive or SharePoint Online are not supported.