Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
@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
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,
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.