Connecting Power BI to an Azure Analysis Services server

Publisert på 1 februar, 2017

Senior Program Manager

Last October we released the preview of Azure Analysis Services, which is built on the proven analytics engine in Microsoft SQL Server Analysis Services. With Azure Analysis Services, you can host semantic data models in the cloud. Users in your organization can then connect to your data models using tools like Excel, Power BI, and many others to create reports and perform ad-hoc data analysis.

This blog will focus on everything you need to know to use Power BI Desktop to build reports against an Azure Analysis Services server and deploy that report to PowerBI.com.

Before getting started, you’ll need:

Connect and create

1. Open Power BI Desktop

2. Click Get Data.

Power BI Desktop

3. Select Databases/SQL Server Analysis Services, and then click connect.

SQL Server Analysis Services Database

4. Enter your Azure AS server name, and click OK.

Connect Live Image

5. On the Navigator screen, select your model, and click OK.

f3f5300d-3108-4e5b-9134-0eb06ac14d2f

You’ll now see your model displayed in the field list on the side. You can drag and drop the different fields on to your page to build out interactive visuals.

image

 

Publish to Power BI

Now that you have created your report, you can publish to Power BI. When published, you can view it online and share it with others.

1. Save the report locally.

2. Click the Publish button on the Home tab.

image

If this is your first time publishing, you’ll be asked to sign in to Power BI.

image

3. Select the destination for your report. This can either be your personal workspace or a group that you are a member of.

4. Once publishing is complete, click the blue link to view the report in Power BI.

image

The report will open in Power BI and will automatically connect to your Azure Analysis Services server.

image

When connecting from Power BI to Azure Analysis Services, you are connected as your Azure Active Directory identity. This is the same identity as you would have used to sign into Power BI. If you share the report to any other users, you must ensure those users have access to your model.

In addition to the report being published, you’ll also see a dataset that has been published.

image

You can use this dataset to create new reports against your Azure Analysis Services model directly in Power BI.

 

Learn more about Azure Analysis Services.