How can we improve Power BI?

Connect Multidimensional to SQL Server Standard License

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.

224 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)

    We’ll send you updates on this idea

    RAZ shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    completed  ·  Admincharles sterling (Admin, Microsoft Power BI) responded  · 

    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!

    27 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Anonymous commented  ·   ·  Flag as inappropriate

        Hi Charles, Did I unterstand it right is it now possible to connect power BI Live with an SSAS Standard Edition? Thanks Greg

      • Anonymous commented  ·   ·  Flag as inappropriate

        Hi Charles, Didi I unterstand it right is it now possible to connect power BI Live with an SSAS Standard Edition? Thanks Greg

      • Alejandro Sosa commented  ·   ·  Flag as inappropriate

        Hi Charles. I agree with @Diederick and @German. This request is not really closed. I think the team needs to continue working to make this backward compatible.

      • German Viera commented  ·   ·  Flag as inappropriate

        Hi Charles.
        This comment should not be marked as completed as the problem described is not solved. Connect to MD models will only work for SQL Server 2016 Standard, but not for previous versions. You are leaving a big gap there. Please reopen thi thread.

      • Barry commented  ·   ·  Flag as inappropriate

        That's awesome! Is it in an update (or future update)? When will this be available? You've got some happy customers if this all works!

      • Mike commented  ·   ·  Flag as inappropriate

        NO WAY!! Really!!! Please tell me we are now able to connect to multi-dim on SQL Server 2012 Standard

      • Barry commented  ·   ·  Flag as inappropriate

        Please make this change to allow Standard License for live connections. Enterprise addition is just not cost effective for most businesses. You have a great product with great potential, but if this change isn't made, we will be forced to look at other products. A response as to why this is not available on Standard would be appreciated.

      • Giswald commented  ·   ·  Flag as inappropriate

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

      • German Viera commented  ·   ·  Flag as inappropriate

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

      • Fredrik Gunne commented  ·   ·  Flag as inappropriate

        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?

      • Giampaolo Pitzalis commented  ·   ·  Flag as inappropriate

        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?

      • Anonymous commented  ·   ·  Flag as inappropriate

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

      • Falgun Oza commented  ·   ·  Flag as inappropriate

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

      • Jesper commented  ·   ·  Flag as inappropriate

        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.

      • Bob M commented  ·   ·  Flag as inappropriate

        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

      ← Previous 1

      Feedback and Knowledge Base

      Ready to get started?

      Try new features of Power BI today by signing up and learn more about our powerful suite of apps.