Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Limitations with SQL Server 2014 Standard? Solution with Direct Query and on-premises SSAS instance

Hi all,   I have just started in a private company (before I was BI/DW-consultant), where I am hired to create a full-blown Power BI solution to take over the QlikView / QlikSence application. How...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    Anonymous

     

    When connecting SSAS in Power BI, only following editions support live connections.

     

    Server version Required SKU
    2012 SP1 CU4 or later Business Intelligence and Enterprise SKU
    2014 Business Intelligence and Enterprise SKU
    2016 Standard SKU or higher

     

    For more details, please see: Manage your data source - Analysis Services.

     

    Regards,

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
9 years ago

Anonymous

 

When connecting SSAS in Power BI, only following editions support live connections.

 

Server version Required SKU
2012 SP1 CU4 or later Business Intelligence and Enterprise SKU
2014 Business Intelligence and Enterprise SKU
2016 Standard SKU or higher

 

For more details, please see: Manage your data source - Analysis Services.

 

Regards,

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    If I have Power BI Premium, and I want to use it on-premises, I need SQL Server.

    But does it need to be 2016, or can it be 2014?

    Can I use the free version of SQL Server alongside PBI Premium?