Analysis Services Live Connection in Power BI | CloudFronts

Analysis Services Live Connection in Power BI

Posted On December 1, 2017 by Anjali Hemmadi Posted in


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


  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.

Share Story :

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.