Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/11331360-connect-multidimensional...
Original problem:
Testing on system running
Windows Server 2012 R2 with latest patches
and
SQL Server 2014 with SP1 x64 with CU3
Analysis services language settings:
System language settings:
Latest Power BI Desktop x64 English installed with preview features enabled:
When adding datasource/connection to SSAS multidimensional database's cube with "Explore live" -setting:
Will receive the following error:
And the "Copy Details" containing info:
And Event Viewer Application Log also showing:
Maybe this is some sort of language mismatch problem? I have tried to change every language setting to en-US but no luck, always the same error.
1035 defines Finnish language whereas 1033 is English(US).
Upgraded the edition from standard to enterprise. Live connection works, no news there.
Standard is then not supported, case closed.
Please vote for adding standard edition to supported list: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/11331360-connect-multidimensional...
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?
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.
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
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
We are running SQL Server 2014 Standard.
Do you mean you have it up and running on 2014 std?
Sorry, no, I don't have it running on sql server 2014 std.
I'm waiting someone to confirm that the Standard version works. I haven't received any confirmations yet.
Enterprise version does work, as some has commented and I have heard this from another source also.
You need BI Ed. min.
Are there any updates to this? I have the Standard edition and am receiving the same errors.
Regards,
John
I am stupid; sorry.
So I have understood the "or later versions" -definition wrong then. If this is the case we have to redo the SQL Server installation.
I hope the documentation would somehow emphasize on the fact that newer SQL Server (2014) is not supported. What about the 2016 version which is just around the corner?
Bjoern edited his answer which made my reply moot. It seems he misread my original post.I'm still leaving my reply but I'm presuming SQL Server 2014 is supported.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
29 | |
12 | |
12 | |
11 | |
8 |
User | Count |
---|---|
54 | |
27 | |
15 | |
14 | |
13 |