cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
linekrogh Member
Member

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.

However, I am worried if I am able to continue with the current server setup - SQL Server 2014 Standard. 

 

I have not been able to find a clear answer on which limitations I might have if to connect to on-premis SSAS (multidimensional cube and/or tabular models) if I use SQL Server 2014 Standard compared to either SQL Server 2014 Enterprise, SQL Server 2016 Standard or SQL Server 2016 Enterprise?

 

Can somebody help or lead me to a place where I find the answers.

 

Bests,

 

Line, Denmark

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-sihou-msft
Moderator

Re: Limitations with SQL Server 2014 Standard? Solution with Direct Query and on-premises SSAS insta

@linekrogh

 

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,

View solution in original post

2 REPLIES 2
Moderator v-sihou-msft
Moderator

Re: Limitations with SQL Server 2014 Standard? Solution with Direct Query and on-premises SSAS insta

@linekrogh

 

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,

View solution in original post

Anonymous
Not applicable

Re: Limitations with SQL Server 2014 Standard? Solution with Direct Query and on-premises SSAS insta

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?

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)