Skip to main content
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Regular Visitor

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:


Original problem:


Testing on system running

Windows Server 2012 R2 with latest patches


SQL Server 2014 with SP1 x64 with CU3

  • DB Engine
  • Integration Services
  • Analysis Services

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:

Error Message:

Couldn't load the model schema.

Stack Trace:

Invocation Stack Trace:

Couldn't load the schema for the database model
Couldn't load the model schema associated with this report. Make sure you have a connection to the server, and try again.

Error details
rsCannotRetrieveModel: An error occurred while loading the model for the item or data source 'EntityDataSource'. Verify that the connection information is correct and that you have permissions to access the data source.

Stack trace
Microsoft.ReportingServices.Diagnostics.Utilities.CannotRetrieveModelException: An error occurred while loading the model for the item or data source 'EntityDataSource'. Verify that the connection information is correct and that you have permissions to access the data source. ---> Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: Errors related to feature availability and configuration: The 'Tabular View' feature is not included in the '64 Bit Standard' edition of Analysis Services.

Activity ID

Fri Dec 11 2015 01:42:38 GMT+0200 (FLE Standard Time)

2.29.4217.341 (PBIDesktop)

And Event Viewer Application Log also showing:

The description for Event ID 25 from source MSOLAP$AnalysisServicesWorkspace405352735 cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:


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).

Regular Visitor

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:

New Member

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


DAX MD is supported since SQL Server 2012 SP1 CU4 and works on BI Edition and above


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.





Continued Contributor
Continued Contributor

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.

Helpful resources

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors