Skip to main content

Power BI

Completed

Connect Multidimensional to SQL Server Standard License

Vote (219) Share
RAZ's profile image

RAZ on 07 Jan 2016 04:54:03

With the removal of the connection to SQL Server Standard License (worked with the first preview) the potentials to a lot of Power BI users is out.
The entire SME business is left out to use this feature although you can still use the connection through Excel and Pivot.
Ideal would be to be moved this license restriction to Power BI Pro account instead of the free version.

Administrator on 09 Jul 2016 00:47:30

Thank you for your suggestion. As you may have seen, with SQL Server 2016 SSAS now enables DAX queries for multi-dimensional models even in standard edition. Closing as the team has completed this work!

Comments (27)
RAZ's profile image Profile Picture

0d172c1c 3f8f-4d46-9d25-2751b65913a0 on 05 Jul 2020 22:23:13

RE: Connect Multidimensional to SQL Server Standard License

What happend to the Business Intelligence Version in SQL Server 2016?
Is this now available in the Standard Edition?

RAZ's profile image Profile Picture

94a20d33 a2cd-42e2-a1ac-69896a4a8461 on 05 Jul 2020 22:22:22

RE: Connect Multidimensional to SQL Server Standard License

Please unlock the access of SSAS MDM Standard Edtion. I´ve tons of customers with this configuration.

RAZ's profile image Profile Picture

d137632d 6c48-4d41-abba-b0ca29c35ef4 on 05 Jul 2020 22:21:44

RE: Connect Multidimensional to SQL Server Standard License

I second Giampaolo's question. Although it is only a few weeks away for RTM (at which point I can try this out myself), it would be great to get this confirmed now:

Will Power BI be able to connect, over Enterprise Gateway, to MDM and Tabular running on SQL Server 2016 Std edition?

RAZ's profile image Profile Picture

98151ea6 f29d-440d-9951-cbb19c589f08 on 05 Jul 2020 22:21:07

RE: Connect Multidimensional to SQL Server Standard License

Considering that SQL Server 2016 Standard Edition allow the possibility to create SSAS Tabular models, can you confirm that PBI gateways will be able to connect both on MDM and Tabular 2016 SE databases?

RAZ's profile image Profile Picture

15847a17 842f-42ce-9919-c7f6897b3047 on 05 Jul 2020 22:21:06

RE: Connect Multidimensional to SQL Server Standard License

Please unlock the SSAS (multidimenstional) power for SQL server standard! All my custumers have the standard edition!

RAZ's profile image Profile Picture

282a4d15 14a6-4b52-80b6-3cf1a0cd8f0b on 05 Jul 2020 22:20:15

RE: Connect Multidimensional to SQL Server Standard License

Power BI without SSAS standard edition gateway becomes useles for many small-mid size companies.

RAZ's profile image Profile Picture

1f6544aa ea4b-48e8-b251-d83894bd33f5 on 05 Jul 2020 22:20:14

RE: Connect Multidimensional to SQL Server Standard License

The reason why Microsoft is only allowing the connector to work with an Enterprise license is about revenue - Microsoft has never cared about customers. It is all about how much mony they can squise out of their customers. I think it is a bad rute they have taken here, at least on the long run, because for many small and medium sized businesses the Enterprice Edition is not an option it is simply too expensive. I am sure they have done a lot of calculations and made the conclusion, that they earn more money this way. This wiil not change before more db people turn away from MSsql to PostGreSQL or some other good alternative. One thing is as sure as the sun goes down every day -Microsoft does not change their atitude to their customer before they are forced to that mean too many customers are leaving them.

RAZ's profile image Profile Picture

555153af 6b6c-4f02-a3b5-3599887fa99f on 05 Jul 2020 22:19:16

RE: Connect Multidimensional to SQL Server Standard License

Please provide ability for Live Connection to SSAS MD SQL server standard. As business and power users, we don't always have control of the versions of the solution provided by IT Infrastructure. This really limits functionality and availability to a large section of the business

RAZ's profile image Profile Picture

c018a192 ff96-4ab8-9ce2-260a6f73790c on 05 Jul 2020 22:18:04

RE: Connect Multidimensional to SQL Server Standard License

Please unlock the SSAS (multidimenstional) power for SQL server standard!

RAZ's profile image Profile Picture

adf78c2e 8d87-4b30-8a4c-93d9f8ab640f on 05 Jul 2020 22:16:57

RE: Connect Multidimensional to SQL Server Standard License

Pls think Std Edition customers also.