Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I have an issue with opening a model I created before. I get the message that te file is encrypted or corrupted.
Some more details of the error message:
InnerException0.Stack Trace Message:
An object with name 'TemplateId' does not exist in the collection.
Parameter name: name
I have the feeling it has to do with the setting of the Time Travelling-functionaliality that was turned on in my model. Those extra LocalDate-tables were created in the model and i used them to add some extra columns fe . Creation Month to the model (with the Tabular Editor Extension)
I can re-open an old file from the model without those extra LocalDate-tables (but offcourse I made a lot of changes after that, so I want to have those data-tables included).
I already tried everal things:
- Reinstall Power Bi Desktop
- Start from a recovered file
Anyone any idea how I can change fe the JSON-file behind the model to get this solved?
Many many thanks!
Leen
Hi @v-tianyich-msft ,
thanks a lot for for your reply. However, I tried to open the file via Tabular Editor as per your suggestion, but this does not work. I get the message: Exception of type 'system.outofmemoryexception'. But I get any model open this way (so that is not related to the issue of the corrupt model I guess). Any other idea? See below all the details fo the error message:
Feedback Type:
Frown (Error)
Timestamp:
2024-02-01T10:59:07.1180285Z
Local Time:
2024-02-01T11:59:07.1180285+01:00
Session ID:
c469ed77-d929-4b78-ac71-4f104ba181b8
Release:
December 2023
Product Version:
2.124.2028.0 (23.12) (x64)
Error Message:
Kan C:\Users\BemindtL\Soudal N.V\Soudataverse - General\PowerBI\MODELS & REPORTS\Sales\Sales Model.pbix niet openen. Het bestand is versleuteld of beschadigd.
Stack Trace:
at Microsoft.PowerBI.Client.Windows.Storage.FileOpenError.HandleError(IWindowService windowService, LocalizedString title)
at Microsoft.PowerBI.Client.Program.TryOpenOrCreateReport(IPowerBIWindowService windowService, ICurrentFileManager currentFileManager, IFileHistoryManager fileHistoryManager, CommandLine commandLine, FileType fileType, IFileInformationProtectionManager fileInformationProtectionManager, IPowerBITelemetryService telemetryService)
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)
Stack Trace Message:
Kan C:\Users\BemindtL\Soudal N.V\Soudataverse - General\PowerBI\MODELS & REPORTS\Sales\Sales Model.pbix niet openen. Het bestand is versleuteld of beschadigd.
Invocation Stack Trace:
at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo..ctor(String message, Exception exception, Nullable`1 stackTraceInfo, String messageDetail)
at Microsoft.PowerBI.Client.PowerBIUnexpectedExceptionHandler.HandleKnownExceptions(Exception e)
at Microsoft.PowerBI.Client.PowerBIUnexpectedExceptionHandler.HandleException(Exception e)
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)
InnerException0.Stack Trace Message:
Een object met de naam TemplateId komt niet voor in de verzameling.
Parameter name: name
InnerException0.Stack Trace:
at Microsoft.AnalysisServices.Tabular.NamedMetadataObjectCollection`2.get_Item(String name)
at Microsoft.PowerBI.Modeler.DateTableDefinition.GetDefinitionColumn(Column column)
at Microsoft.PowerBI.Modeler.DateTableSubsystem.Upgrade()
at Microsoft.PowerBI.Modeling.Engine.Authoring.SchemaChangeApplier.Apply(IModelEditor modelEditor, IEnumerable`1 changes, IRefreshPolicyUpdater refreshPolicyUpdater, IPrivateInformationService privateInformationService)
at Microsoft.PowerBI.Modeling.Engine.Authoring.AsyncModelAuthoringService.ModelAuthoringTransaction.<>c__DisplayClass27_0.<ExecuteChange>b__0(IEnumerable`1 changes)
at Microsoft.PowerBI.Modeling.Engine.Authoring.AsyncModelAuthoringService.ModelAuthoringTransaction.ExecuteChange(ModelChange modelChange, Boolean isTrustedSource, Boolean saveChange, ISchemaChangeApplierFactory schemaChangeApplierFactory, IRefreshPolicyUpdater refreshPolicyUpdater, IPrivateInformationService piiService, String descriptionToTrace)
at Microsoft.PowerBI.Modeling.Engine.Authoring.AsyncModelAuthoringService.ExtendedModelChangeScope.ExecuteChange(ModelChange modelChange, Boolean isTrustedSource, Boolean saveChange, String descriptionToTrace)
at Microsoft.PowerBI.Modeling.Engine.Upgrade.ModelUpgrader.EnableTimeIntelligenceAndUpdateSchema(IDataModel dataModel, IExtendedModelChangeScope scope)
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__DisplayClass9_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, ModelingMashupDocument modelingMashupDocument, String currentProductVersion, IEmbeddedValueUpgrader embeddedValueUpgrader, Boolean areV3UpgradeErrorsFatal, Boolean forceUpgrade)
at Microsoft.PowerBI.Modeling.Engine.Authoring.AsyncModelAuthoringService.ExtendedModelChangeScope.<>c__DisplayClass32_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__DisplayClass19_0.<UpgradeModel>b__0(IExtendedModelChangeScope scope)
at Microsoft.PowerBI.Modeling.Engine.Authoring.AsyncModelAuthoringService.<>c__DisplayClass11_0.<RunExtendedModelChangeAsync>b__0(IExtendedModelChangeScope scope)
at Microsoft.PowerBI.Modeling.Engine.Authoring.AsyncModelAuthoringService.<>c__DisplayClass12_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__15.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__30.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__19.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__9.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__4.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.BiPackageOperationHandler.<LoadPbiFile>d__19.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.CurrentFileManager.<ExecuteAndHandleFileOpenErrors>d__42.MoveNext()
InnerException0.Invocation Stack Trace:
at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.GetFeedbackValuesFromException(Exception e, String prefix)
at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.GetFeedbackValuesFromInnerExceptions(Exception e, Int32 depth)
at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.CreateAdditionalErrorInfo(Exception e)
at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo..ctor(String message, Exception exception, Nullable`1 stackTraceInfo, String messageDetail)
at Microsoft.PowerBI.Client.PowerBIUnexpectedExceptionHandler.HandleKnownExceptions(Exception e)
at Microsoft.PowerBI.Client.PowerBIUnexpectedExceptionHandler.HandleException(Exception e)
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)
OS Version:
Microsoft Windows NT 10.0.19045.0 (x64 en-US)
CLR Version:
4.8 or later [Release Number = 528372]
Peak Virtual Memory:
70 GB
Private Memory:
422 MB
Peak Working Set:
680 MB
IE Version:
11.3636.19041.0
User ID:
373dc10a-8fe2-4395-b6bc-c1035922ab89
Telemetry Enabled:
True
PowerBINonFatalError_ErrorCode:
InvalidReportFile
InnerException0.ModelChangeResult:
{"changes":[{"upgradeDateTables":{}}]}
DPI Scale:
125%
Supported Services:
Power BI
See below the details of the error message:
Hi @LeenBem ,
You can try changing the .pbix file to a .zip file and then open the corresponding file via TabularEditor. Finally, change the file type to .pbix, remembering to do this with a backup file.
Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
94 | |
85 | |
78 | |
68 | |
63 |
User | Count |
---|---|
113 | |
99 | |
97 | |
64 | |
59 |