Analysis Services Live Connection in Power BI

Introduction:

In this article, we will learn how to configure Live connection for Analysis Services in Power BI.

Requirements:

1. Power BI Licence
2. SQL Server Analysis Service
3. Power BI Gateway (Refer this link to configure Power BI Gateway)

Steps to Connect Analysis Services Live in PowerBI

1. Open PowerBI Desktop
2. Click Get Data and Select Analysis Services
3. In the Analysis Services Connection details, select Live Connection Mode for Live Connection.
   
4. Once the Data, Measures, KPIs are loaded you can create Power BI Dashboard. Live Connection enabled status is visible at the right bottom of the Power BI Desktop.
5. Before publishing the Dashboard, login into Power BI Service.
6. Under Manage Gateway, we must add a data source for Analysis Services.
   

   Note: The account should be a Server Admin on the Analysis Server and should be a domain account in the same domain that the Analysis Services instance is located. (Click here for more information on Analysis Server Connection)

7. Go back to Power BI Desktop and publish the Power BI dashboard.
   
8. In the Power BI Service, under the Reports you will be able to see the published Live SQL dashboard.