My first step with Azure Analysis Service

Azure Analysis Service (AAS) is an enterprise grade semantic analytical data modelling tool for BI & reporting. In this short blog, we’ll document the steps required to configure AAS and will create a sample report using Power BI Desktop.

To start with, we’ll first provision an Azure SQL Database to host the data. AAS supports various data sources, full list is here.

Create a SQL Database

We’ll create an Azure SQL Database Server and a database.

Select a Subscription, Resource group, input Database name and Server.

For this blog, we’ll select ‘Public endpoint’ as ‘Connectivity method’.

We’ll select some sample data instead of a blank database.

Installing Azure Analysis Service

In this section, we’ll create an instance of Analysis Service.