cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

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
Highlighted
Microsoft
Microsoft

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
Highlighted
Microsoft
Microsoft

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

Highlighted
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
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Kudoed Authors