PBI Desktop can't load schema.

[akaratr]

Somehow, my PBI report shows error suddenly with below error details. 
Any suggestion, pls.

Feedback Type:
Frown (Error)

Error Message:
CsdlConvertXmlToConceptualSchema

Stack Trace:
at Microsoft.PowerBI.ExploreHost.SemanticQuery.SemanticTranslationBaseFlow.InternalRun()
at Microsoft.PowerBI.ExploreHost.ExploreClient.TranslateDataViewQueryDefinition(DataViewQueryDefinition definition, String databaseID)
at Microsoft.PowerBI.Client.Windows.AnalysisServices.Relationships.ModelDseQueryBuilder.TranslateToDax(QueryDefinition queryDefinition)
at Microsoft.PowerBI.Client.Windows.AnalysisServices.Relationships.ModelQueryExecutor.<>c__DisplayClass4_0.<GetRowCount>b__0()
at Microsoft.PowerBI.Modeler.EngineCancellableCall.Perform()
at Microsoft.PowerBI.Client.Windows.AnalysisServices.Relationships.ModelQueryExecutor.GetRowCount(CancellationToken cancellationToken)
at Microsoft.PowerBI.Client.Windows.AnalysisServices.Relationships.ModelDataSource.GetTableRowCount(ModelQueryInfo`2 queryInfo, CancellationToken cancellationToken)
at Microsoft.PowerBI.Client.Windows.AnalysisServices.Relationships.ModelAsyncDataSource.<>c__DisplayClass14_0.<GetTableRowCount>b__0(CancellationToken cancellationToken)
at System.Threading.Tasks.ContinuationResultTaskFromTask`1.InnerInvoke()
at System.Threading.Tasks.Task.Execute()
--- 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.Client.Windows.HtmlControls.DataExploreView.DataExploreViewHtmlControl.<>c__DisplayClass46_0.<<RaiseDataViewChangedEvent>b__0>d.MoveNext()
--- 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.Client.Windows.IExceptionHandlerExtensions.<HandleAwaitableAsyncExceptions>d__1.MoveNext()

Stack Trace Message:
CsdlConvertXmlToConceptualSchema

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.Windows.Utilities.UIBlockingAwareExceptionHandler.HandleException(Exception e)
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.PowerBI.Client.Windows.HtmlControls.DataExploreView.DataExploreViewHtmlControl.OnActiveSchemaItemChanged(EventArgsBase e)
at Microsoft.Practices.Prism.PubSubEvents.EventSubscription`1.<>c__DisplayClass2.<GetExecutionStrategy>b__0(Object[] arguments)
at Microsoft.Practices.Prism.PubSubEvents.EventBase.InternalPublish(Object[] arguments)
at Microsoft.PowerBI.Client.Windows.Services.EventAggregationService.<>c__DisplayClass27_0`2.<<PublishInternal>b__1>d.MoveNext()
at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
at Microsoft.PowerBI.Client.Windows.Services.EventAggregationService.<>c__DisplayClass27_0`2.<PublishInternal>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.PowerBI.Client.Windows.Services.EventAggregationService.Publish[TEvent](EventArgsBase eventArgs)
at Microsoft.PowerBI.Client.Windows.Services.SchemaItemActivationService.SetActiveItem(SchemaItem schemaItem, Boolean raiseEventOnChange)
at Microsoft.PowerBI.Client.Windows.SchemaItemActivationHostService.<>c__DisplayClass3_0.<SetActiveSchemaItem>b__0()
at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.<>c__DisplayClass0_1.<SendAndMarshalExceptions>b__0(Object null)
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.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
at System.Windows.Forms.Control.InvokeMarshaledCallbacks()
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
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.WebDialogs.WebDialog.<>n__0(IWindowHandle owner)
at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
at Microsoft.PowerBI.Client.Program.<>c__DisplayClass4_0.<Main>b__1()
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)

Model Default Mode:
Import

Snapshot Trace Logs:
C:\Users\akara\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot970778132.zip

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

Enabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_showIncrementalRefreshPolicy
PBI_showManageAggregations
PBI_improvedFilterExperience
PBI_qnaLiveConnect
PBI_keyDrivers

Disabled Preview Features:
PBI_SpanishLinguisticsEnabled
PBI_NewWebTableInference

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

OLEDB_ErrorInfo_IsReported:
True

Formulas:

section Section1;

shared bi_ap = let
Source = MySQL.Database("kks.getmyip.com", "as_kksprod_utf8_2009", [ReturnSingleDatabase=true]),
as_kksprod_utf8_2009_bi_ap = Source{[Schema="as_kksprod_utf8_2009",Item="bi_ap"]}[Data],
#"Changed Type" = Table.TransformColumnTypes(as_kksprod_utf8_2009_bi_ap,{{"ap_name", type text}, {"NAME", type text}, {"ap_address", type text}, {"ap_tel", type text}})
in
#"Changed Type";

shared bi_ar = let
Source = MySQL.Database("kks.getmyip.com", "as_kksprod_utf8_2009", [ReturnSingleDatabase=true]),
as_kksprod_utf8_2009_bi_ar = Source{[Schema="as_kksprod_utf8_2009",Item="bi_ar"]}[Data]
in
as_kksprod_utf8_2009_bi_ar;

shared bi_item = let
Source = MySQL.Database("kks.getmyip.com", "as_kksprod_utf8_2009", [ReturnSingleDatabase=true]),
as_kksprod_utf8_2009_bi_item = Source{[Schema="as_kksprod_utf8_2009",Item="bi_item"]}[Data]
in
as_kksprod_utf8_2009_bi_item;

shared bi_sale_report = let
Source = MySQL.Database("kks.getmyip.com", "as_kksprod_utf8_2009", [ReturnSingleDatabase=true]),
as_kksprod_utf8_2009_bi_sale_report = Source{[Schema="as_kksprod_utf8_2009",Item="bi_sale_report"]}[Data],
#"Renamed Columns" = Table.RenameColumns(as_kksprod_utf8_2009_bi_sale_report,{{"qty", "น้ำหนัก กก หลัก qty"}, {"qty1", "เส้น รอง qty1"}}),
#"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns",{{"requested_date", type text}}),
#"Renamed Columns1" = Table.RenameColumns(#"Changed Type",{{"น้ำหนัก กก หลัก qty", "หน่วยหลัก กก qty"}, {"เส้น รอง qty1", "หน่วยรอง เส้น qty1"}}),
#"Changed Type1" = Table.TransformColumnTypes(#"Renamed Columns1",{{"requested_date", type datetime}})
in
#"Changed Type1";

shared bi_item_len = let
Source = MySQL.Database("kks.getmyip.com", "as_kksprod_utf8_2009", [ReturnSingleDatabase=true]),
as_kksprod_utf8_2009_bi_item_len = Source{[Schema="as_kksprod_utf8_2009",Item="bi_item_len"]}[Data],
#"Removed Columns" = Table.RemoveColumns(as_kksprod_utf8_2009_bi_item_len,{"stock_type", "one_digit", "typename", "two_digit", "kindname", "tree_digit", "shape", "size", "unitname", "oppositeunitname", "turning", "grade"})
in
#"Removed Columns";

shared bi_so_is_in = let
Source = MySQL.Database("kks.getmyip.com", "as_kksprod_utf8_2009", [ReturnSingleDatabase=true]),
as_kksprod_utf8_2009_bi_so_is_in = Source{[Schema="as_kksprod_utf8_2009",Item="bi_so_is_in"]}[Data],
#"Changed Type" = Table.TransformColumnTypes(as_kksprod_utf8_2009_bi_so_is_in,{{"so_duedate", type datetime}, {"so_docdate", type datetime}, {"in_docdate", type datetime}, {"is_duedate", type datetime}, {"tp_docdate", type datetime}, {"qo_docdate", type datetime}})
in
#"Changed Type";

shared #"ABC Parameter" = let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45Wcs5JLC5W0lHKyS9PLYpPyi/NS0ksqgQKlBYUIAvE6kQrOQKFDUBYzxzMd4KyQaQlWMQZytZRMlSKjQUA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t, Column3 = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}}),
#"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{"Column1", "Class"}}),
#"Promoted Headers" = Table.PromoteHeaders(#"Renamed Columns", [PromoteAllScalars=true]),
#"Changed Type1" = Table.TransformColumnTypes(#"Promoted Headers",{{"Class", type text}, {"lower_boundary", type number}, {"upper_boundary", type number}})
in
#"Changed Type1";

shared customer = let
Source = Excel.Workbook(File.Contents("C:\Users\akara\OneDrive\KKS\BI Master Files\customer master.xlsx"), null, true),
customer_Sheet = Source{[Item="customer",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(customer_Sheet, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"คำนำหน้าชื่อ", type text}, {"ประเภทลูกค้า", type text}, {"กลุ่มลูกค้า", type text}, {"หมวดลูกค้า", type text}, {"รหัสลูกค้า", type any}, {"สถานะ 3ปี", type text}, {"ชื่อSale", type text}, {"รหัสSale", Int64.Type}, {"ที่อยู่ลูกค้า", type any}, {"ตำบล/ แขวง", type any}, {"อำเภอ/เขต", type any}, {"จังหวัด", type any}, {"รหัสไปรษณี", Int64.Type}, {"เบอร์โทรศัพท์", type any}, {"เบอร์โทรสาร", type any}, {"Customer Group", type text}})
in
#"Changed Type";

shared #"ไฟล์ AutoPart Excel" = let
Source = Excel.Workbook(File.Contents("C:\Users\akara\OneDrive\KKS\BI Master Files\บัญชีรายชื่อสินค้า Auto Part.xlsx"), null, true),
#"สินค้า Auto part_Sheet" = Source{[Item="สินค้า Auto part",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(#"สินค้า Auto part_Sheet", [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Column1", Int64.Type}, {"บัญชีรายชื่อสินค้า Autp Part", type text}, {"Column3", type text}, {"Column4", type text}, {"Column5", type text}, {"Column6", type text}, {"Column7", type any}}),
#"Promoted Headers1" = Table.PromoteHeaders(#"Changed Type", [PromoteAllScalars=true]),
#"Changed Type1" = Table.TransformColumnTypes(#"Promoted Headers1",{{"Column1", Int64.Type}, {"AR.Code", type text}, {"ชื่อลูกค้า", type text}, {"item code", type text}, {"ชื่อสินค้า", type text}, {"เกรด", type text}, {"ความยาว (เมตร)", type number}}),
#"Renamed Columns" = Table.RenameColumns(#"Changed Type1",{{"Column1", "NO."}})
in
#"Renamed Columns";

shared bi_purchase_report = let
Source = MySQL.Database("kks.getmyip.com", "as_kksprod_utf8_2009", [ReturnSingleDatabase=true]),
as_kksprod_utf8_2009_bi_purchase_report = Source{[Schema="as_kksprod_utf8_2009",Item="bi_purchase_report"]}[Data]
in
as_kksprod_utf8_2009_bi_purchase_report;

shared #"as_kksprod_utf8_2009 bi_stock_month" = let
Source = MySQL.Database("kks.getmyip.com", "as_kksprod_utf8_2009", [CreateNavigationProperties=false, ReturnSingleDatabase=true]),
as_kksprod_utf8_2009_bi_stock_month = Source{[Schema="as_kksprod_utf8_2009",Item="bi_stock_month"]}[Data]
in
as_kksprod_utf8_2009_bi_stock_month;

[v-qiuyu-msft]

Hi @akaratr, 

Which action do you perform then the issue occurs? 

What's your Power BI desktop version? How about the result if you update your Power BI desktop to the latest version 2.69.5467.2151? 

Best Regards,
Qiuyun Yu