Advantages and Limitations of Live Connect Type in Power BI

Business Problem: I have received so many requests about the people are not able to understand about different kind of connection types and limitations of each connection type in Power BI. The people who are not able to answer in interviews for this question.I am going to explain all connection types and Limitations and advantages.   

Solution:

There are 3 type of connections in Power BI

   1) Connect Live
   2) Import
   3) Direct Query

 Connect Live:-

•  This Type of connection only Available for SQL Server Analysis Services.You can directly        access already built in SSAS Model. (Multi dimensional,Tabular Model).
•  When you publish a Power BI Desktop file with a live connection to a Tabular model to your   Power BI site, an On-premises Data Gateway must be installed and configured.
•  Live Connection directly accesses a model/cube searching for Tabular metadata and querying  in DAX from SSAS Cube.

Connect Live

  




Supported Systems:  
                                   SSAS Multidimensional 
                                   SSAS Tabular
  
  Advantages:

•  This is most Securable and Robust method for building and maintaining a Power BI Solution.
•  The Data is Located in On-Premises.

 Limitations:

• Servers must be running SQL Server 2012 SP1 CU4 or later versions of Analysis Services for the Power BI Desktop SSAS MD connector to work properly.

• Cell level Formatting and translation features are not supported.
• Live Connection requires Enterprise level SQL
• Actions and Named Sets in Cube are not exposed to Power BI.
• We Can create report level measures in the Power BI Desktop, 
• All other Edit query and modelling Data Tab features are disabled when exploring live data.