cancel
Showing results for 
Search instead for 
Did you mean: 

Cannot load model - Desktop

Hello everyone,

Since yesterday, I cannot connect to my Power BI Service dataset in the desktop version.

The dataset is uploaded to a Premium Workspace in my organization. It has been working perfectly for over a year until yesterday.

Strangely enough, the reports already published work perfectly, but if I open a pbix file to make any adjustments, the connection issue persists. See error-details copied below.

Any help would be warmly appreciated. 





Feedback Type:
Frown (Error)

Timestamp:
2020-06-30T08:18:27.1971527Z

Local Time:
2020-06-30T10:18:27.1971527+02:00

Session ID:
ecce75ad-9a5b-45e7-b204-68fb7b72c7fa

Release:
June, 2020

Product Version:
2.82.5858.961 (20.06) (x64)

Stack Trace:
Microsoft.PowerBI.ReportingServicesHost.CannotRetrieveModelException: An error occurred while loading the model. Verify that the connection information is correct and that you have permissions to access the data source. ---> Microsoft.PowerBI.DataExtension.Contracts.DataExtensionException: Failed to open the MSOLAP connection. ---> MsolapWrapper.MsolapWrapperException: Could not initialize connection
at MsolapWrapper.Utils.ThrowErrorIfHrFailed(Int32 hr, String message)
at MsolapWrapper.Connection.Open()
at Microsoft.PowerBI.DataExtension.Msolap.Connection.OpenImpl()
--- End of inner exception stack trace ---
at Microsoft.PowerBI.DataExtension.Msolap.Connection.OpenImpl()
at Microsoft.PowerBI.DataExtension.Contracts.Utilities.RunSynchronously(Action action)
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.ReportingServicesHost.PoolableConnectionWrapper.<OpenAsync>d__8.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Microsoft.PowerBI.ReportingServicesHost.Utils.TaskExtensions.WaitAndUnwrapException(Task task)
at Microsoft.PowerBI.ReportingServicesHost.LocalReportProcessingHost.ExecuteSchemaCommand[T](ExploreHostDataSourceInfo dataSourceInfo, IDbConnectionPool connectionPool, IConnectionFactory connectionFactory, IConnectionUserImpersonator connectionUserImpersonator, QueryExecutionOptionsBase queryExecutionOptions, ITelemetryService telemetryService, Func`2 action, String failTelemetryMessage, ServiceErrorStatusCode statusCode, ExploreBaseEvent exploreEvent)
--- End of inner exception stack trace ---
at Microsoft.PowerBI.ReportingServicesHost.LocalReportProcessingHost.ExecuteSchemaCommand[T](ExploreHostDataSourceInfo dataSourceInfo, IDbConnectionPool connectionPool, IConnectionFactory connectionFactory, IConnectionUserImpersonator connectionUserImpersonator, QueryExecutionOptionsBase queryExecutionOptions, ITelemetryService telemetryService, Func`2 action, String failTelemetryMessage, ServiceErrorStatusCode statusCode, ExploreBaseEvent exploreEvent)
at Microsoft.PowerBI.ReportingServicesHost.LocalReportProcessingHost.<>c__DisplayClass9_0.<GetModelMetadata>b__1(ExploreBaseEvent timedEvent)
at Microsoft.PowerBI.ReportingServicesHost.ExploreTelemetryService.<>c__DisplayClass4_0`1.<RunInActivity>b__0(ExploreBaseEvent activity)
at Microsoft.PowerBI.ReportingServicesHost.ExploreTelemetryService.RunInActivity(String activityName, Action`1 action)
at Microsoft.PowerBI.ReportingServicesHost.ExploreTelemetryService.RunInActivity[T](String activityName, Func`2 action)
at Microsoft.PowerBI.ReportingServicesHost.LocalReportProcessingHost.GetModelMetadata(ExploreHostDataSourceInfo dataSourceInfo, IDbConnectionPool connectionPool, IConnectionFactory connectionFactory, String modelMetadataVersion, QueryExecutionOptionsBase queryExecutionOptions, IConnectionUserImpersonator connectionUserImpersonator, ITelemetryService telemetryService)
at Microsoft.PowerBI.ReportingServicesHost.ReportingSession.GetModel(String dataSourceName, String modelMetadataVersion)
at Microsoft.PowerBI.ReportingServicesHost.ReportingSession.GetModelAsStream(String dataSourceName, String modelMetadataVersion)
at Microsoft.PowerBI.ReportingServicesHost.ReportingSession.GetConceptualSchema(String modelMetadataVersion, ParseConceptualSchema parse, ModelDaxCapabilities& capabilities)
at Microsoft.PowerBI.ExploreHost.Utils.ExploreHostUtils.GetConceptualSchemaImpl(IPowerViewHandler powerViewHandler, String databaseID, String maxModelMetadataVersion, ModelDaxCapabilities& capabilities)
at Microsoft.PowerBI.ExploreHost.Utils.ExploreHostUtils.HandleModelRetrievalExceptions[T](Func`1 wrappedCall, String databaseID, ServiceErrorStatusCode statusCode, FeatureSwitches featureSwitches)
at Microsoft.PowerBI.ExploreHost.Utils.ExploreHostUtils.GetConceptualSchemaAndHandleExceptions(IPowerViewHandler powerViewHandler, String databaseID, String maxModelMetadataVersion, ModelDaxCapabilities& daxCapabilities)
at Microsoft.PowerBI.ExploreHost.Utils.ExploreHostUtils.<>c__DisplayClass26_0.<TryGetConceptualSchema>b__0()
at Microsoft.PowerBI.ExploreHost.Utils.ExploreHostUtils.TryGetStructureImpl[T](Int64 modelID, ServiceErrorExtractor extractor, Func`1 getStructure, Func`2 validateStructure, T& structure, ServiceError& serviceError)

OS Version:
Microsoft Windows NT 6.1.7601 Service Pack 1 (x64 en-US)

CLR Version:
4.7 or later [Release Number = 528049]

Peak Virtual Memory:
4.05 GB

Private Memory:
405 MB

Peak Working Set:
552 MB

IE Version:
11.0.9600.19723

User ID:
3a2545f4-9792-4429-8f42-149f62763a8f

Workbook Package Info:
1* - sv-SE, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.

Telemetry Enabled:
True

AS Live Connection:
True

Enabled Preview Features:
PBI_NewWebTableInference
PBI_modelViewASLiveConnect

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_inlineExplore
PBI_v3ModelsPreview
PBI_relativeTimeSlicer
PBI_dataSearchCuration

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

Status: New
Comments
Community Support

@ras_ile ,

 

I have made a test on my side but I couldn't reproduce this issue. Power bi dataset can be connected in power bi desktop. My power bi desktop version: 2.82.5858.961 64-bit (June 2020) and tenant: East US 2 (Virginia). If this issue persists, I would suggest you create a support ticket here for further analysis.

Support Ticket.gif 

Regards,

Jimmy Tao