An internal error prevented loading the model schema associated with this report

[Kitikarn]

Hi All,

I am using Power BI desktop and I have this error pop up for this report. 

Other reports are fine except this report. Would you please help? Thanks!

Feedback Type:
Frown (Error)

Error Message:
An internal error prevented loading the model schema associated with this report. Please try again later. If the issue persists, contact Power BI support.

Stack Trace:
Javascript: Error
at Microsoft.PowerBI.ExploreHost.Utils.ExploreHostUtils.GetEngineDataModel(Stream modelStream, IFeatureSwitchProvider featureSwitchProvider)
at Microsoft.PowerBI.ReportingServicesHost.ModelMetadataProvider.GetEngineDataModel(ModelMetadataRequest request, IFeatureSwitchProvider featureSwitchProvider, Func`3 parse)
at Microsoft.PowerBI.ExploreHost.Utils.ExploreHostUtils.GetEngineDataModelImpl(IPowerViewHandler powerViewHandler, String databaseID, String maxModelMetadataVersion, Nullable`1 translationsBehavior)
at Microsoft.PowerBI.ExploreHost.Utils.ExploreHostUtils.HandleModelRetrievalExceptions[T](Func`1 wrappedCall, ServiceErrorStatusCode statusCode)
at Microsoft.PowerBI.ExploreHost.Utils.ExploreHostUtils.GetEngineDataModelAndHandleExceptions(IPowerViewHandler powerViewHandler, String databaseID, String maxModelMetadataVersion, Nullable`1 translationsBehavior)
at Microsoft.PowerBI.ExploreHost.Utils.ExploreHostUtils.<>c__DisplayClass30_0.<TryGetEngineDataModel>b__0()
at Microsoft.PowerBI.ExploreHost.Utils.ExploreHostUtils.TryGetStructureImpl[T](Int64 modelID, ServiceErrorExtractor extractor, Func`1 getStructure, Func`2 validateStructure, T& structure, ServiceError& serviceError)

Stack Trace Message:
An internal error prevented loading the model schema associated with this report. Please try again later. If the issue persists, contact Power BI support.

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.Telemetry.PowerBIUserFeedbackServices.GetStackTraceInfo(Exception e)
at Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture)
at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass14_0.<HandleException>b__0()
at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)
at Microsoft.PowerBI.Client.PowerBIUnexpectedExceptionHandler.HandleException(Exception e)
at Microsoft.PowerBI.Client.Windows.Utilities.PowerBIFormUnexpectedExceptionHandler.HandleException(Exception e)
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.WebView2.WebView2Interop.InvokeCs(InteropCall call)
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__DisplayClass6_0.<RunApplication>b__0()
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.RunApplication(String[] args)
at Microsoft.PowerBI.Client.Program.Main(String[] args)

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.118.828.0","ModuleName":"","Component":"","Error":"Error","MethodDef":"","ErrorOffset":"-1:-1","ErrorCode":""}

Snapshot Trace Logs:
C:\Users\kitikarn\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot6103af1a-8ecd-47ca-abdd-f01d0b285664.zip

Model Default Mode:
Composite

Model Version:
PowerBI_V3

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

Enabled Preview Features:
PBI_b2bExternalDatasetSharing
PBI_enableWebView2
PQ_WebView2Connector
PBI_sparklines
PBI_scorecardVisual
PBI_NlToDax
PBI_fieldParametersSuperSwitch
PBI_horizontalFusion
PBI_setLabelOnExportPdf
PBI_newCard

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_enhancedTooltips
PBI_angularRls
PBI_onObject
PBI_dynamicFormatString
PBI_oneDriveSave
PBI_oneDriveShare
PBI_gitIntegration

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

PowerBIUserFeedbackServices_IsReported:
True

Formulas:

section Section1;

shared #"DirectQuery to AS - THA_Roojai_Policy" = let
Source = AnalysisServices.Database("powerbi://api.powerbi.com/v1.0/myorg/Thailand", "THA_Roojai_Policy"),
Cubes = Table.Combine(Source[Data]),
Cube = Cubes{[Id="Model", Kind="Cube"]}[Data]
in
Cube;

shared #"DirectQuery to AS - THA_Kumka_Policy" = let
Source = AnalysisServices.Database("powerbi://api.powerbi.com/v1.0/myorg/Kumka", "THA_Kumka_Policy"),
Cubes = Table.Combine(Source[Data]),
Cube = Cubes{[Id="Model", Kind="Cube"]}[Data]
in
Cube;

shared #"DirectQuery to AS - THA_Roojai_Claim" = let
Source = AnalysisServices.Database("powerbi://api.powerbi.com/v1.0/myorg/Thailand", "THA_Roojai_Claim"),
Cubes = Table.Combine(Source[Data]),
Cube = Cubes{[Id="Model", Kind="Cube"]}[Data]
in
Cube;

shared #"DirectQuery to AS - THA_Roojai_AWS_Connect" = let
Source = AnalysisServices.Database("powerbi://api.powerbi.com/v1.0/myorg/Thailand", "THA_Roojai_AWS_Connect"),
Cubes = Table.Combine(Source[Data]),
Cube = Cubes{[Id="Model", Kind="Cube"]}[Data]
in
Cube;

shared #"DirectQuery to AS - THA_Roojai_RNL_Conversion_Motor" = let
Source = AnalysisServices.Database("powerbi://api.powerbi.com/v1.0/myorg/Thailand", "THA_Roojai_RNL_Conversion_Motor"),
Cubes = Table.Combine(Source[Data]),
Cube = Cubes{[Id="Model", Kind="Cube"]}[Data]
in
Cube;

shared #"DirectQuery to AS - THA_Roojai_RNL_Conversion_Protection" = let
Source = AnalysisServices.Database("powerbi://api.powerbi.com/v1.0/myorg/Thailand", "THA_Roojai_RNL_Conversion_Protection"),
Cubes = Table.Combine(Source[Data]),
Cube = Cubes{[Id="Model", Kind="Cube"]}[Data]
in
Cube;

shared #"DirectQuery to AS - THA_Roojai_RNL_Conversion_Protection 2" = let
Source = AnalysisServices.Database("powerbi://api.powerbi.com/v1.0/myorg/Thailand", "THA_Roojai_RNL_Conversion_Protection"),
Cubes = Table.Combine(Source[Data]),
Cube = Cubes{[Id="Model", Kind="Cube"]}[Data]
in
Cube;

shared #"Fact KK portfolio" = let
Source = Sql.Database("rj-synapse-ondemand.sql.azuresynapse.net", "DWH_THA_KUMKA", [Query="SELECT [PortfolioDate]#(lf) ,policyCount = sum([PolicyCount])#(lf) ,Annual_Net_Premium = sum(Annual_Net_Premium)#(lf) ,[ContractStartDate]#(lf) ,[Product_type]#(lf) ,[Insurer]#(lf) ,[Sale_channel]#(lf) ,convert(date,InsertDate) InsertDate#(lf) #(lf) FROM [dbo].[fact_portfolio] #(lf) WHERE Lower(Sale_channel) = 'kumka_broker'#(lf) and Lower(Product_type) <> 'rsa'#(lf) group by PortfolioDate,policyCount,Annual_Net_Premium,ContractStartDate,Product_type,Insurer,Sale_channel,InsertDate"])
in
Source;

shared Fact_INDO_portfolio = let
Source = Sql.Database("rj-synapse-ondemand.sql.azuresynapse.net", "DWH_IDN_ROOJAI", [Query="SELECT [PortfolioDate]#(lf) ,policyCount = sum([PolicyCount])#(lf) ,Annual_Net_Premium = sum(Annual_Net_Premium)#(lf) ,[ContractStartDate]#(lf) ,[Product_type]#(lf) ,[Insurer]#(lf) #(lf) ,convert(date,InsertDate) InsertDate#(lf) #(lf) FROM [dbo].[fact_portfolio] #(lf)#(lf) group by PortfolioDate,policyCount,Annual_Net_Premium,ContractStartDate,Product_type,Insurer,InsertDate"])
in
Source;

shared #"No Of Customer INDO" = let
Source = Sql.Database("rj-synapse-ondemand.sql.azuresynapse.net", "SF_IDN_ROOJAI", [Query="select Product_Type = CASE WHEN Product_Type in ('Neuro','OrganFailure','Dengue','Cardiovascular') then 'CriticalIllness' else Product_Type end#(lf),count(distinct o.id) PIF#(lf),count(distinct o.AccountId) No_of_customer#(lf), ViewDate = convert(date,getdate()) #(lf)from DWH_IDN_ROOJAI.dbo.fact_policy_gwp p#(lf)inner join opportunity o on p.OpportunityId = o.id#(lf)inner join quote q on o.Latest_Transacted_Quote__c = q.Quote_Number_Integer__c --and q.Transaction_Type__c != 'Cancellation'#(lf)inner join Contract c on o.contractid = c.id and c.status in ('Activated', 'Cancelled')#(lf)where q.[Start_date__c] <= convert(date,getdate()) #(lf)and iif(q.Transaction_Type__c != 'Cancellation', q.[Endorse_Effective_Date__c],q.End_Date__c) >= convert(date,getdate()) #(lf)and p.Transaction_Type = 'New Biz'#(lf)-- and p.OpportunityId not in (select OpportunityId from DWH_THA_ROOJAI.dbo.fact_cancellation)#(lf)group by Product_Type#(lf)#(lf)Union all#(lf)#(lf)select Product_Type = CASE WHEN Product_Type in ('Neuro','OrganFailure','Dengue','Cardiovascular') then 'CriticalIllness' else Product_Type end#(lf), count(distinct o.id) PIF#(lf),count(distinct o.AccountId) No_of_customer#(lf),ViewDate = convert(date,getdate()-365) #(lf)from DWH_IDN_ROOJAI.dbo.fact_policy_gwp p#(lf)inner join opportunity o on p.OpportunityId = o.id#(lf)inner join quote q on o.Latest_Transacted_Quote__c = q.Quote_Number_Integer__c --and q.Transaction_Type__c != 'Cancellation'#(lf)inner join Contract c on o.contractid = c.id and c.status in ('Activated', 'Cancelled')#(lf)where q.[Start_date__c] <= convert(date,getdate()-365) #(lf)and iif(q.Transaction_Type__c != 'Cancellation', q.[Endorse_Effective_Date__c],q.End_Date__c) >= convert(date,getdate()-365)#(lf)and p.Transaction_Type = 'New Biz'#(lf)-- and p.OpportunityId not in (select OpportunityId from DWH_THA_ROOJAI.dbo.fact_cancellation)#(lf)group by Product_Type", CreateNavigationProperties=false])
in
Source;

shared #"No Of Customer KK2" = let
Source = Sql.Database("rj-synapse-ondemand.sql.azuresynapse.net", "SF_THA_KUMKA", [Query="--DECLARE @date datetime;#(lf)--SET @date = GETDATE();#(lf)select p.Product_Type__c,viewdate = convert(date,GETDATE()),#(lf)#(lf) count(distinct o.AccountId) No_of_customer,#(lf)#(tab)#(tab) CASE when p.Product_Type__c is not null then 'Kumka_Broker' END Sale_channel#(lf)#(lf) from [DWH_THA_KUMKA].[dbo].[fact_policy] p#(lf)#(lf)inner join opportunity o on (p.OpportunityId = o.Id collate Latin1_General_100_BIN2_UTF8)#(lf)#(lf)inner join quote q on o.Latest_Transacted_Quote__c = q.Quote_Number_Integer__c and q.Transaction_Type__c != 'Cancellation'#(lf)#(lf)inner join Contract c on o.contractid = c.id and c.status = 'Activated'#(lf)#(lf)where q.[Start_date__c] <= convert(date,getdate()) and q.End_Date__c >= convert(date,getdate()) #(lf)#(lf)-- and p.OpportunityId not in (select OpportunityId from DWH_THA_ROOJAI.dbo.fact_cancellation)#(lf)#(lf)group by p.Product_Type__c#(lf)#(lf) #(lf)#(lf)UNION ALL#(lf)#(lf)--DECLARE @date1 date;#(lf)--SET @date1 = GETDATE();#(lf)#(lf)select t.Product_Type collate Latin1_General_100_BIN2_UTF8,viewdate = convert(date,GETDATE()),count(distinct r.AccountId) No_of_customer,#(lf)CASE when t.Product_Type is not null then 'Roojai_Broker' END Sale_channel#(lf)#(lf)from DWH_THA_ROOJAI.dbo.fact_policy t #(lf)#(lf)inner join SF_THA_ROOJAI.dbo.opportunity r on t.OpportunityId = r.id collate Latin1_General_100_BIN2_UTF8#(lf)#(lf)inner join SF_THA_ROOJAI.dbo.quote s on r.Latest_Transacted_Quote__c = s.Quote_Number_Integer__c and s.Transaction_Type__c != 'Cancellation'#(lf)#(lf)inner join SF_THA_ROOJAI.dbo.Contract a on r.contractid = a.id and a.status = 'Activated'#(lf)#(lf)where s.[Start_date__c] <= convert(date,getdate()) and s.End_Date__c >= convert(date,getdate()) #(lf)#(lf)and lower(t.Leadsource) = 'mrkumka'#(lf)#(lf)group by t.Product_Type#(lf)#(lf)#(lf)UNION ALL#(lf)#(lf)#(lf)select p.Product_Type__c,viewdate = convert(date,getdate()-365),#(lf)#(lf) count(distinct o.AccountId) No_of_customer,#(lf)#(tab)#(tab) CASE when p.Product_Type__c is not null then 'Kumka_Broker' END Sale_channel#(lf)#(lf) from [DWH_THA_KUMKA].[dbo].[fact_policy] p#(lf)#(lf)inner join opportunity o on (p.OpportunityId = o.Id collate Latin1_General_100_BIN2_UTF8)#(lf)#(lf)inner join quote q on o.Latest_Transacted_Quote__c = q.Quote_Number_Integer__c and q.Transaction_Type__c != 'Cancellation'#(lf)#(lf)inner join Contract c on o.contractid = c.id and c.status = 'Activated'#(lf)#(lf)where q.[Start_date__c] <= convert(date,getdate()-365) and q.End_Date__c >= convert(date,getdate()-365) #(lf)#(lf)-- and p.OpportunityId not in (select OpportunityId from DWH_THA_ROOJAI.dbo.fact_cancellation)#(lf)#(lf)group by p.Product_Type__c#(lf)#(lf) #(lf)#(lf)UNION ALL#(lf)#(lf) #(lf)#(lf)select t.Product_Type collate Latin1_General_100_BIN2_UTF8,viewdate = convert(date,getdate()-365),count(distinct r.AccountId) No_of_customer,#(lf)CASE when t.Product_Type is not null then 'Roojai_Broker' END Sale_channel#(lf)#(lf)from DWH_THA_ROOJAI.dbo.fact_policy t #(lf)#(lf)inner join SF_THA_ROOJAI.dbo.opportunity r on t.OpportunityId = r.id collate Latin1_General_100_BIN2_UTF8#(lf)#(lf)inner join SF_THA_ROOJAI.dbo.quote s on r.Latest_Transacted_Quote__c = s.Quote_Number_Integer__c and s.Transaction_Type__c != 'Cancellation'#(lf)#(lf)inner join SF_THA_ROOJAI.dbo.Contract a on r.contractid = a.id and a.status = 'Activated'#(lf)#(lf)where s.[Start_date__c] <= convert(date,getdate()-365) and s.End_Date__c >= convert(date,getdate()-365) #(lf)#(lf)and lower(t.Leadsource) = 'mrkumka'#(lf)#(lf)group by t.Product_Type#(lf)#(lf)#(lf)#(lf)"])
in
Source;

shared #"DirectQuery to AS - THA_Kumka_WebLog" = let
Source = AnalysisServices.Database("powerbi://api.powerbi.com/v1.0/myorg/Kumka", "THA_Kumka_WebLog"),
Cubes = Table.Combine(Source[Data]),
Cube = Cubes{[Id="Model", Kind="Cube"]}[Data]
in
Cube;

shared #"DirectQuery to AS - ID_daily_report" = let
Source = AnalysisServices.Database("powerbi://api.powerbi.com/v1.0/62b6b46c-b6f8-40cb-b174-2f8c9cb6a656/Indonesia", "ID_daily_report"),
Cubes = Table.Combine(Source[Data]),
Cube = Cubes{[Id="Model", Kind="Cube"]}[Data]
in
Cube;