Forum Discussion

Regular Visitor

10 years ago

Error connecting SSAS multidimensional data source (preview feature: explore live)

Solved with upgrading to enterprise edition. Standard edition is not supported with explore live from multidimensional data source. Please vote for adding standard edition to supported list: http...

Advocate I

10 years ago

Error indicates an issue with SQL version. I tried on different servers and got the same error when using SQL Std edition, everything worked on SQL Ent edition servers. Is there a version limitation on this feature? Anyone managed to get it working on SQL Std?

nax123
Advocate I
10 years ago
I hope Microsoft clarifies the edition requirement -from PowerBi Eneterprise Gateway announcement it is clear that DAX MD is required which is not part of standard edition. Also there is no support for DAX MD for pre SQL 2012? As most of our customers are still running 2008 R2 Std, it would be great to know if there will be live connectivity support for this version (and std edition support for later cersions), otherwise PowerBI offer would need to start with upgrade request.
- johnchill
  Helper I
  10 years ago
  We are running SQL Server 2014 Standard.
  - nax123
    Advocate I
    10 years ago
    Do you mean you have it up and running on 2014 std?
- fbrossard
  Kudo Commander
  10 years ago
  DAX MD is supported since SQL Server 2012 SP1 CU4 and works on BI Edition and above
  See https://msdn.microsoft.com/en-us/library/cc645993(v=sql.120).aspx
- fbrossard
  Kudo Commander
  10 years ago
  DAX MD is supported since SQL Server 2012 SP1 CU4 and works on BI Edition and above
  See https://msdn.microsoft.com/en-us/library/cc645993(v=sql.120).aspx
johnchill
Helper I
10 years ago
Are there any updates to this? I have the Standard edition and am receiving the same errors.

Regards,

John