Unable to open .pbix file in Power BI Desktop - "failed to update the linguistic schema"

[micham]

Hi,

A report I created two years ago fails to open in Power BI Desktop. I tried both the archived .pbix file and also downloading a report from Power BI service to .pbix and opening it. In both cases Power BI Desktop will not open a file - shows "failed to update the linguistic schema" error

Details:

Feedback Type:
Frown (Error)

Timestamp:
2022-08-08T10:04:56.0625999Z

Local Time:
2022-08-08T12:04:56.0625999+02:00

Session ID:
d1118e7a-51b5-40e9-8d8d-764b68120a48

Release:
March 2022

Product Version:
2.103.881.0 (22.03) (x64)

Stack Trace:
System.InvalidOperationException
at Microsoft.PowerBI.Lucia.LinguisticSchemaContainer.EnsureSchema()
at Microsoft.PowerBI.Lucia.LinguisticSchemaContainer.UpgradeIfNeeded(Func`1 getConceptualSchema, String defaultContent, Func`2 doAdditionalUpgrades)
at Microsoft.PowerBI.Modeler.ModelManager.UpgradeLinguisticSchema()
at Microsoft.PowerBI.Modeling.Engine.Authoring.SchemaChangeApplier.Apply(IModelManager modelManager, IEnumerable`1 changes, IRefreshPolicyUpdater refreshPolicyUpdater, IPrivateInformationService privateInformationService)
at Microsoft.PowerBI.Modeling.Engine.Authoring.AsyncModelAuthoringService.ModelAuthoringTransaction.ExecuteChange(ModelChange modelChange, Boolean saveChange, ISchemaChangeApplierFactory schemaChangeApplierFactory, IRefreshPolicyUpdater refreshPolicyUpdater, IPrivateInformationService piiService, String descriptionToTrace)
at Microsoft.PowerBI.Modeling.Engine.Authoring.AsyncModelAuthoringService.ExtendedModelChangeScope.ExecuteChange(ModelChange modelChange, Boolean saveChange, RecalcBehavior recalcBehavior, String descriptionToTrace)
at Microsoft.PowerBI.Modeling.Engine.Upgrade.ModelUpgrader.RunPreV3UpgradesImpl(IExtendedModelChangeScope scope, ModelUpgradeResult upgradeResult, IDataModel dataModel, ModelingMashupDocument mashupDocument, String currentProductVersion)
at Microsoft.PowerBI.Modeling.Engine.Upgrade.ModelUpgrader.<>c__DisplayClass8_0.<RunPreV3Upgrades>b__0()
at Microsoft.PowerBI.Modeling.Engine.Upgrade.ModelUpgrader.ExecuteAndSaveOrCommit(IExtendedModelChangeScope modelChangeScope, Action actionToExecute, String description, Func`2 throwOnSaveOrCommitException)
at Microsoft.PowerBI.Modeling.Engine.Upgrade.ModelUpgrader.UpgradeModel(IExtendedModelChangeScope modelChangeScope, IModelingSession modelingSession, ModelingSettings modelingSettings, ModelingMashupDocument modelingMashupDocument, String currentProductVersion, IEmbeddedValueUpgrader embeddedValueUpgrader, Boolean areV3UpgradeErrorsFatal, Boolean forceUpgrade)
at Microsoft.PowerBI.Modeling.Engine.Authoring.AsyncModelAuthoringService.ExtendedModelChangeScope.<>c__DisplayClass29_0.<UpgradeModel>b__0()
at Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingTelemetryService.<>c__DisplayClass6_0`1.<RunInActivity>b__0()
at Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingTelemetryService.RunInActivity(ModelingActivityKind activity, Action action)
at Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingTelemetryService.RunInActivity[T](ModelingActivityKind activity, Func`1 action)
at Microsoft.PowerBI.Client.Windows.Modeling.Hosting.DesktopModelingHost.<>c__DisplayClass18_0.<UpgradeModel>b__0(IExtendedModelChangeScope scope)
at Microsoft.PowerBI.Modeling.Engine.Authoring.AsyncModelAuthoringService.<>c__DisplayClass9_0.<RunExtendedModelChangeAsync>b__0(IExtendedModelChangeScope scope)
at Microsoft.PowerBI.Modeling.Engine.Authoring.AsyncModelAuthoringService.<>c__DisplayClass10_0.<<RunExtendedModelChangeAsync>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.Modeling.Engine.Authoring.AsyncModelAuthoringService.<ContinueWithAsyncOperation>d__13.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.Modeling.Hosting.DesktopModelingHost.<RunOutOfBandExtendedModelChange>d__29.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.Modeling.Hosting.DesktopModelingHost.<UpgradeModel>d__18.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.ReportUpgrader.<Upgrade>d__5.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.ReportPreparer.<UpgradeModel>d__16.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.ReportPreparer.<Prepare>d__8.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.Services.PowerBIPackagingService.<Open>d__5.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.Services.FileManager.<LoadFromPbix>d__24.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.Services.UIBlockingService.<>c__DisplayClass13_0`1.<<BlockUIAndRun>b__0>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Microsoft.PowerBI.Client.Windows.Services.UIBlockingService.WaitOnUIThreadForTaskCompletion[T](Task`1 task)
at Microsoft.PowerBI.Client.Windows.Services.UIBlockingService.BlockUIAndRun[T](Func`1 asyncMethod)
at Microsoft.PowerBI.Client.Windows.Services.FileManager.OpenFile(IPowerBIWindowService windowService, IPbixFile fileToOpen, Nullable`1 entryPoint)
at Microsoft.PowerBI.Client.Program.TryOpenOrCreateReport(IPowerBIWindowService windowService, IFileManager fileManager, IFileHistoryManager fileHistoryManager, String filePath, FileType fileType, IFileInformationProtectionManager fileInformationProtectionManager)
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)

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.103.881.0","ModuleName":"Microsoft.PowerBI.Lucia.Contracts.dll","Component":"Microsoft.PowerBI.Lucia.LinguisticSchemaContainer","Error":"System.InvalidOperationException","MethodDef":"EnsureSchema","ErrorOffset":"75"}

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

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

Peak Virtual Memory:
53.9 GB

Private Memory:
428 MB

Peak Working Set:
566 MB

IE Version:
11.1.22621.0

User ID:
2fc18f18-9130-4740-a46e-72e72e61ab37

Telemetry Enabled:
True

DPI Scale:
200%

Supported Services:
Power BI

[v-xiaoyan-msft]

Hi @micham ,

We see that you are using the March 2022 version of Power BI Desktop, does this problem occur if you update to the latest version?
Have you tried clearing the cache of Power BI Desktop?

Best Regards,
Community Support Team _ Caitlyn