Learn how to connect to Azure Analysis Services with Power BI (2023)

  • Article
  • 2 minutes to read

After you've created a server in Azure and deployed a tabular model to it, users in your organization are ready to connect and begin exploring data.


If publishing a Power BI Desktop model to the Power BI service, on the Azure Analysis Services server, ensure the Case-Sensitive collation server property is not selected (default). The Case-Sensitive server property can be set by using SQL Server Management Studio.

(Video) Azure Analysis Services Tutorial | Scale Power BI reports into hundreds of GBs

Connect in Power BI Desktop

  1. In Power BI Desktop, click Get Data > Azure > Azure Analysis Services database.

  2. In Server, enter the server name. Be sure to include the full URL; for example, asazure://westcentralus.asazure.windows.net/advworks.

    (Video) Power BI Walkthrough: Analysis Services Live Connect

  3. In Database, if you know the name of the tabular model database or perspective you want to connect to, paste it here. Otherwise, you can leave this field blank and select a database or perspective later.

  4. Select a connection option and then press Connect.

    Both Connect live and Import options are supported. However, we recommended you use live connections because Import mode does have some limitations; most notably, server performance might be impacted during import.

    If you have a Power BI model in Mixed storage mode, the Connect live option is replaced by the DirectQuery option. Live connections are also automatically upgraded to DirectQuery if the model is switched from Import to Mixed storage mode.

    (Video) Power BI Integration With Azure | Power BI Azure Tutorial For Beginners | K21Academy

  5. When prompted to enter your credentials, select Microsoft account, and then click Sign in.

    Learn how to connect to Azure Analysis Services with Power BI (1)


    (Video) What is Azure Analysis Services? How to handle large datasets in Power BI? AAS Tutorial | Azure | 4K

    Windows and Basic authentication are not supported.

  6. In Navigator, expand the server, then select the model or perspective you want to connect to, and then click Connect. Click a model or perspective to show all objects for that view.

    The model opens in Power BI Desktop with a blank report in Report view. The Fields list displays all non-hidden model objects. Connection status is displayed in the lower-right corner.

Connect in Power BI (service)

  1. Create a Power BI Desktop file that has a live connection to your model on your server.
  2. In Power BI, click Get Data > Files, and then locate and select your .pbix file.

Request Memory Limit

To safeguard the performance of the system, a memory limit is enforced for all queries issued by Power BI reports against Azure Analysis Services, regardless of the Query Memory Limit configured on the Azure Analysis Services server. Users should consider simplifying the query or its calculations if the query is too memory intensive.

(Video) Getting Started with Azure Analysis Services

Query typeRequest Memory limit
Live connect from Power BI10 GB
DirectQuery from Power BI report in Shared workspace1 GB
DirectQuery from Power BI report in Premium workspace10 GB
Power BI Q&A100 MB

See also

Connect to Azure Analysis Services
Client libraries


1. Setting up Azure Analysis Services and Connecting Power BI to it
2. Azure Data Lake, Azure Analysis Services and Power BI
(BI Insight)
3. Power BI Quick Tip : ​DirectQuery Support for Azure Analysis Services
(Data Platform Central)
4. Microsoft Power BI: Enterprise modeling with Power BI and Azure Analysis Services - BRK3064
(Microsoft Power BI)
5. Power BI Academy: Power BI with Azure Analysis Services
(FreshBI Reporting Inc.)
6. Roadmap for Semantic Models: from Azure AS to Power BI Premium
(Microsoft Power BI)
Top Articles
Latest Posts
Article information

Author: Kieth Sipes

Last Updated: 31/07/2023

Views: 5736

Rating: 4.7 / 5 (67 voted)

Reviews: 82% of readers found this page helpful

Author information

Name: Kieth Sipes

Birthday: 2001-04-14

Address: Suite 492 62479 Champlin Loop, South Catrice, MS 57271

Phone: +9663362133320

Job: District Sales Analyst

Hobby: Digital arts, Dance, Ghost hunting, Worldbuilding, Kayaking, Table tennis, 3D printing

Introduction: My name is Kieth Sipes, I am a zany, rich, courageous, powerful, faithful, jolly, excited person who loves writing and wants to share my knowledge and understanding with you.