model.bim file issues - 'Multiple SaveChanges without transaction' - error log provided

[seanify]

Hello,

I have an extremely problematic issue that has surfaced over the weekend seemingly - I am unable to open any of my reports associated with my main 'Digital Model' semantic model, including the main model file itself. This is a serious issue given I'm right in the middle of delivering a number of reports using this new model to the business.

The initial error message states there is a problem with the \Digital Model.SemanticModel\model.bim content in my Power BI Project. Multiple SaveChanges without transaction. I provide a detailed error at the end of this message, but the main point is that the DataModelLoad failed.

A few points to consider:
- I am using the Git repo approach, I can confirm that only I have made any changes to the repo- the last edit at all to model.bim was on Friday evening.

- The model and associated reports are working perfectly in Power BI service, I have even pushed a new report (which I cannot now update, ha) to the service, and this works fine.

- Pulling the model.bim file from the remote repo / Service and comparing it to my local version confirms no differences.

- This model is setup to incrementally refresh, and so version history etc looks to be locked out as a result

- I use Tabular Editor each time I reupload model.bim to switch the RangeStart parameter back to an earlier date- as there is a non-foldable query that is not incrementally refreshed, which annoyingly retains the RangeStart/End date range in the model if I don't set this. This hasn't caused any issues like this before now though.

- I recently also had to remove some erroneous data, which led to me needing to remote refresh the partitions of one table using SQL Server Management Studio's XMLA endpoint- not sure if this would cause anything, given it doesn't actually change a bim file.

I would very much appreciate any insights! I'm intrigued by the InnerException1.ModelChangeResult section at the end of the error below... might this be saying where the issue lies? (Which might well be the incremental refresh policy?)

Thanks,

Sean

Feedback Type:
Frown (Error)

Timestamp:
2025-02-25T17:10:24.4065944Z

Local Time:
2025-02-25T17:10:24.4065944+00:00

Session ID:
2f6eef8c-9c37-4443-8a65-a7e31633d603

Release:
February 2025

Product Version:
2.140.1078.0 (25.02)+2cce24fb16e8b71ba835921d23e7ffc1fab909df (x64)

Error Message:
There's a problem with the C:\repos\Power BI - Digital Analytics\Digital Model.SemanticModel\model.bim content in your Power BI Project.
Multiple SaveChanges without transaction

Stack Trace:
   at Microsoft.PowerBI.Client.Windows.Services.BiProjectOperationHandler.<LoadFromProject>d__35.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.BiProjectOperationHandler.<LoadFromPbip>d__33.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.BiProjectOperationHandler.<LoadArtifact>d__28.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.CurrentArtifactManager.<ExecuteAndHandleFileOpenErrors>d__55.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.CurrentArtifactManager.<>c__DisplayClass36_0.<<OpenArtifactAndSetAsCurrent>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.Services.UIBlockingService.<>c__DisplayClass17_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, PowerBIProgress progress)
   at Microsoft.PowerBI.Client.Windows.Services.CurrentArtifactManager.OpenArtifactAndSetAsCurrent(IPowerBIWindowService windowService, IPowerBIArtifact artifactToOpen, IExceptionHandler exceptionHandler, Nullable`1 entryPoint)
   at Microsoft.PowerBI.Client.CommandLineFileService.TryOpenOrCreateReport(IPowerBIWindowService windowService, IExceptionHandler exceptionHandler, Boolean forceCreate)
   at Microsoft.PowerBI.Client.Program.<>c__DisplayClass7_0.<RunApplicationLegacy>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:
Multiple SaveChanges without transaction

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.RunApplicationLegacy(String[] args, IPowerBIRootTrace trace)
   at Microsoft.PowerBI.Client.Program.Main(String[] args)


InnerException0.Stack Trace Message:
Multiple SaveChanges without transaction

InnerException0.Stack Trace:
   at Microsoft.PowerBI.Client.Windows.Services.LocalAnalysisServicesDatabaseCreator.<CreateAnalysisServicesDatabaseAsync>d__7.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.BiProjectOperationHandler.<LoadFromProject>d__35.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.RunApplicationLegacy(String[] args, IPowerBIRootTrace trace)
   at Microsoft.PowerBI.Client.Program.Main(String[] args)


InnerException1.Stack Trace Message:
Multiple SaveChanges without transaction

InnerException1.Stack Trace:
   at Microsoft.PowerBI.Modeling.Common.Contract.FailCore(String msg)
   at Microsoft.PowerBI.Modeler.ModelManager.TransactionlessTransactionStrategy.SaveChanges()
   at Microsoft.PowerBI.Modeler.ModelManager.InternalTransaction.<>c__DisplayClass13_1.<SaveChanges>b__2()
   at Microsoft.PowerBI.Modeler.TomExtensions.ExecuteTomOperation(Action action)
   at Microsoft.PowerBI.Modeler.ModelManager.InternalTransaction.<>c__DisplayClass13_0.<SaveChanges>b__0()
   at Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingTelemetryService.<>c__DisplayClass9_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.Modeler.ModelManager.InternalTransaction.SaveChanges(String description)
   at Microsoft.PowerBI.Modeler.ModelManager.InternalTransaction.SaveChangesForCommit(String description, Boolean recalc)
   at Microsoft.PowerBI.Modeler.ModelManager.InternalTransaction.Commit(Boolean recalc)
   at Microsoft.PowerBI.Modeling.Engine.Authoring.AsyncModelAuthoringService.ModelAuthoringTransaction.Commit(RecalcBehavior recalcBehavior)
   at Microsoft.PowerBI.Client.Windows.Modeling.Utilities.ModelChangeScopeExtensions.ExecuteAndCommitTrustedChangeAsSingleTransaction(IExtendedModelChangeScope scope, ModelChange modelChange, Boolean validateChange, RecalcBehavior recalcBehavior, String descriptionToTrace)
   at Microsoft.PowerBI.Client.Windows.AnalysisServices.TmslApplier.<>c__DisplayClass4_0.<ApplySchemaChanges>b__0(IExtendedModelChangeScope scope)
   at Microsoft.PowerBI.Client.Windows.Modeling.Hosting.DesktopModelingHost.<>c__DisplayClass25_0.<RunOutOfBandExtendedModelChange>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.AnalysisServices.TmslApplier.<ApplySchemaChanges>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.AnalysisServices.TmslApplier.<ApplyTmsl>d__3.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.AnalysisServices.AnalysisServicesService.<LoadDatabaseFromStreamAndSchema>d__42.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.LocalAnalysisServicesDatabaseCreator.<CreateAnalysisServicesDatabaseAsync>d__7.MoveNext()

InnerException1.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.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.RunApplicationLegacy(String[] args, IPowerBIRootTrace trace)
   at Microsoft.PowerBI.Client.Program.Main(String[] args)


OS Version:
Microsoft Windows NT 10.0.19045.0 (x64 en-GB)

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

Peak Virtual Memory:
70.2 GB

Private Memory:
499 MB

Peak Working Set:
648 MB

IE Version:
11.3636.19041.0

User ID:
8fa7e994-16da-4200-9f30-45c732656ca5

Telemetry Enabled:
True

PowerBINonFatalError_ErrorCode:


InnerException0.PowerBINonFatalError_ErrorCode:
DataModelLoadFailed

InnerException1.ModelChangeResult:
{"changes":[{"entityRefresh":{"entity":"ga_session","RefreshType":"ClearValues"}},{"entityRefresh":{"entity":"ga_session_flags","RefreshType":"ClearValues"}},{"entityRefresh":{"entity":"journey_web_investments","RefreshType":"ClearValues"}},{"entityRefresh":{"entity":"journey_web_savings","RefreshType":"ClearValues"}},{"entityRefresh":{"entity":"journey_app_investments","RefreshType":"ClearValues"}},{"entityRefresh":{"entity":"journey_app_savings","RefreshType":"ClearValues"}},{"entityRefresh":{"entity":"ga_journey_all","RefreshType":"ClearValues"}},{"entityRefresh":{"entity":"ga_e_plan","RefreshType":"ClearValues"}},{"entityRefresh":{"entity":"ga_e","RefreshType":"ClearValues"}},{"entityRefresh":{"entity":"ga_e_path","RefreshType":"ClearValues"}},{"entityRefresh":{"entity":"ga_e_detail","RefreshType":"ClearValues"}}]}

DPI Scale:
250%

Supported Services:
Power BI

[n8ball · Accepted solution]

OK. I just fixed it for me. I'm using the TMDL serialization.

1. Open the pbi folder in the *.SemanticModel folder.
2. Delete cache.adf. 
3. Load the Power BI project in Power BI desktop and it should load. The data will need to be rehydrated since the cache file was removed.

[alana_i]

Why wouldn't having cache.abf in the gitignore file work?

[Johag]

Same here, deleted the cache.abf and then open the project. Worked for me. 

A tip to prevent this from happen again is to add the cache-file to .gitignore. 

[dendenharmet]

This worked for me! I only deleted the cache.abf under .pbi folder. Thanks!

[Bejan]

Hi thanks for this n8ball. I deleted only the cache.abf file and it seems to be working fine again

[Anonymous]

Hi,  @Bejan 
We are very pleased to hear that the issue has been resolved. Thank you for sharing the solution with us. If you are willing, you might consider accepting this solution, as it can also help other community members facing the same issue find a solution more quickly.

Of course, if there is anything else we can do for you, please do not hesitate to contact us. Once again, thank you for your contribution, and we look forward to your response.

Best Regards,

Leroy Lu

[n8ball]

I too am also having this issue with a TMDL PBIP project. Made edits in VsCode and used Git to push to the service and the model seems to be working fine there.