Forum Discussion

mahenkj2's avatar
mahenkj2
Icon for Solution Sage rankSolution Sage
4 years ago
Solved

Help on error: Couldn't load the database schema for the databsae model

Hi,

I am trying to install Desktop Jun release since last few weeks. I have been working with May version and it is working fine. Upon installation to Jun version, I see following error in my all the existing Desktop files, whether they are very basic simple versions created few years ago, or the latest properly designed files:

 

 

Couldn't load the database schema for the database model: We couldn't retrieve the data model for this report. Please try again later.

 

 

I also copy the error content, if it is helpful to diagnose the problem:

 

 

Feedback Type:
Frown (Error)

Timestamp:
2022-07-10T03:31:34.0768875Z

Local Time:
2022-07-10T09:01:34.0768875+05:30

Session ID:
8f184e72-0c93-4e73-b9c1-8af315b90faf

Release:
June 2022

Product Version:
2.106.883.0 (22.06) (x64)

Error Message:
We couldn't retrieve the data model for this report. Please try again later.

Stack Trace:
   at Microsoft.PowerBI.ReportingServicesHost.ModelMetadataProvider.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.ModelMetadataProvider.<>c__DisplayClass10_1.<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.ModelMetadataProvider.GetModelMetadata(ModelMetadataRequest request)
   at Microsoft.PowerBI.ReportingServicesHost.ModelMetadataProvider.GetConceptualSchema(ModelMetadataRequest request, ConceptualSchemaBuilderOptions builderOptions, ParseConceptualSchema parse)
   at Microsoft.PowerBI.ReportingServicesHost.ReportingSession.GetConceptualSchema(String modelMetadataVersion, Nullable`1 translationsBehavior, ParseConceptualSchema parse)
   at Microsoft.PowerBI.ExploreHost.Utils.ExploreHostUtils.<>c__DisplayClass33_0.<GetConceptualSchema>b__0()
   at Microsoft.PowerBI.ExploreHost.Utils.ExploreHostUtils.HandleModelRetrievalExceptions[T](Func`1 wrappedCall, ServiceErrorStatusCode statusCode)
   at Microsoft.PowerBI.ExploreHost.Utils.ExploreHostUtils.GetConceptualSchemaAndHandleExceptions(Func`1 getConceptualSchema, String maxModelMetadataVersion, ModelDaxCapabilities& daxCapabilities)
   at Microsoft.PowerBI.ExploreHost.Utils.ExploreHostUtils.GetConceptualSchema(IPowerViewHandler powerViewHandler, String databaseID, String maxModelMetadataVersion, Nullable`1 translationsBehavior, 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)

Invocation Stack Trace:
   at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
   at Microsoft.Mashup.Client.UI.Shared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace, String exceptionMessage)
   at Microsoft.PowerBI.Client.Windows.ErrorHostService.GetErrorDetails(ShowErrorDialogArgs args)
   at Microsoft.PowerBI.Client.Windows.ErrorHostService.<>c__DisplayClass5_0.<ShowErrorDialogCore>b__0()
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
   at System.Delegate.DynamicInvokeImpl(Object[] args)
   at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
   at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
   at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
   at System.Windows.Forms.Control.InvokeMarshaledCallbacks()
   at System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate method, Object[] args, Boolean synchronous)
   at System.Windows.Forms.Control.Invoke(Delegate method, Object[] args)
   at System.Windows.Forms.WindowsFormsSynchronizationContext.Send(SendOrPostCallback d, Object state)
   at Microsoft.PowerBI.Client.Windows.Services.UIBlockingService.AllowModalDialogs(Action action)
   at Microsoft.PowerBI.Client.Windows.HostServiceDispatcher.<>c__DisplayClass14_0.<ExecuteOnUIThreadAndHandlePromise>b__0()
   at Microsoft.PowerBI.Client.Windows.HostServiceDispatcher.ExecuteOnUIThreadAndHandlePromise[T](Func`1 func, IPromiseStore promiseStore, Int64 promiseHandle)
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   at Microsoft.PowerBI.Client.Windows.HostServiceDispatcher.<ExecuteInteropCsMethod>d__15.MoveNext()
   at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine)
   at Microsoft.PowerBI.Client.Windows.HostServiceDispatcher.ExecuteInteropCsMethod(Object interopObj, MethodInfo method, Object[] arguments)
   at Microsoft.PowerBI.Client.Windows.WebView2.WebView2Interop.<>c__DisplayClass20_0.<<InvokeCs>b__1>d.MoveNext()
   at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
   at Microsoft.PowerBI.Client.Windows.WebView2.WebView2Interop.<>c__DisplayClass20_0.<InvokeCs>b__1()
   at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<HandleAwaitableAsyncExceptions>d__1.MoveNext()
   at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
   at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.HandleAwaitableAsyncExceptions(IExceptionHandler exceptionHandler, Func`1 asyncFunc)
   at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<HandleAsyncExceptions>d__0.MoveNext()
   at System.Runtime.CompilerServices.AsyncVoidMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
   at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.HandleAsyncExceptions(IExceptionHandler exceptionHandler, Func`1 asyncFunc)
   at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
   at System.EventHandler`1.Invoke(Object sender, TEventArgs e)
   at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
   at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
   at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
   at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
   at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
   at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
   at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
   at Microsoft.PowerBI.Client.Program.<>c__DisplayClass4_1.<Main>b__2()
   at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass3_0.<HandleExceptionsWithNestedTasks>b__0()
   at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
   at Microsoft.PowerBI.Client.Program.Main(String[] args)


OS Version:
Microsoft Windows NT 10.0.17763.0 (x64 en-US)

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

Peak Virtual Memory:
53.6 GB

Private Memory:
424 MB

Peak Working Set:
619 MB

IE Version:
11.1790.17763.0

User ID:
5b214fcd-eaea-4fc5-8dbf-36990af6686a

Workbook Package Info:
1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: False.

Telemetry Enabled:
True

Snapshot Trace Logs:
C:\Users\Administrator\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot5a95f1df-b203-4113-b4c1-6724ca86af11.zip

Model Default Mode:
Composite

Model Version:
PowerBI_V3

Performance Trace Logs:
C:\Users\Administrator\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip

Enabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_enableWebView2
PBI_mobileAuthoringFormattingUI
PBI_sparklines
PBI_lineChartError

Disabled Preview Features:
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_azureMapVisual
PBI_compositeModelsOverAS
PBI_enhancedTooltips
PQ_WebView2Connector
PBI_scorecardVisual
PBI_fieldParametersSuperSwitch

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
125%

Supported Services:
Power BI

 

 

I can wait for Jul release, but not sure if even that would solve the problem.

 

Thanks.

  • mahenkj2's avatar
    mahenkj2
    4 years ago

    Hi v-xiaotang ,

     

    I was about to check thesuggested links bu couldn't all these days, and meanwhile saw July release coming in. So today I dowloaded and tested, it worked fine. So I seem to have no probelm with May version and as well as July version.

     

    Thanks for your support.

4 Replies

  • We have a user who just hit the same error.  She installed the June 2022 version and hit the error on the first attempt to connect to a data set.

     

    OS Version:

    Microsoft Windows NT 10.0.19044.0 (x64 en-US)

     

    CLR Version:

    4.8 or later [Release Number = 528372]

     

    Peak Virtual Memory:

    53.9 GB

     

    Private Memory:

    426 MB

     

    Peak Working Set:

    566 MB

     

    IE Version:

    11.789.19041.0

     

    Workbook Package Info:

    1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: False.

     

    Telemetry Enabled:

    True

    Model Default Mode:

    Empty

     

    Model Version:

    PowerBI_V1

    Enabled Preview Features:

    PBI_enableWebView2

    PBI_mobileAuthoringFormattingUI

    PBI_sparklines

     

    Disabled Preview Features:

    PBI_shapeMapVisualEnabled

    PBI_SpanishLinguisticsEnabled

    PBI_qnaLiveConnect

    PBI_azureMapVisual

    PBI_compositeModelsOverAS

    PBI_enhancedTooltips

    PQ_WebView2Connector

    PBI_scorecardVisual

    PBI_lineChartError

    PBI_fieldParametersSuperSwitch

     

    Disabled DirectQuery Options:

    TreatHanaAsRelationalSource

     

    Cloud:

    USGovCloud

     

    DPI Scale:

    125%

     

    Supported Services:

    Power BI

     

    Formulas:

     

     

    section Section1;

     

  • v-xiaotang's avatar
    v-xiaotang
    Icon for Community Support rankCommunity Support

    Hi mahenkj2 

    Thanks for reaching out to us.

    >> I am trying to install Desktop Jun release since last few weeks. I have been working with May version and it is working fine. Upon installation to Jun version, I see following error in my all the existing Desktop files

    Does the solution in these two posts help?

    powerbi - Power Bi Desktop- Couldn't load the schema for the database model - Stack Overflow

    Not able to open PBI file (even new blank one) - Microsoft Power BI Community

     

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

    • MCPD-IT's avatar
      MCPD-IT
      New Member

      The user confirms that uninstalling and reverting back to the May 2022 version (x64) solved this issue.

       

       

    • mahenkj2's avatar
      mahenkj2
      Icon for Solution Sage rankSolution Sage

      Hi v-xiaotang ,

       

      I was about to check thesuggested links bu couldn't all these days, and meanwhile saw July release coming in. So today I dowloaded and tested, it worked fine. So I seem to have no probelm with May version and as well as July version.

       

      Thanks for your support.