Model loading error

[Joan_Roig]

Hi,

With any change in the computer or data source, today the data isn't loading into the model, PowerQuery it seems works and update well, but at the end of the model update process I get this error:

"An unexpected exception occurred.
Unexpected error (file "", line , function "").
The current operation was canceled because an error occurred in another operation of the transaction"

As you can see, it doesn't provede any information about a epecific file or function....

Do someone any idea about on where I should look?

Thnaks

Part of error message:

Feedback Type:
Frown (Error)

Timestamp:
2025-05-29T16:24:05.0503297Z

Local Time:
2025-05-29T18:24:05.0503297+02:00

Session ID:
1589e7cb-d2f9-4a85-88ed-fc21e7103f4f

Release:
May 2025

Product Version:
2.143.878.0 (25.05)+b20aa3b866ec1b70879135a4e60e4b1301c75b21 (x64)

Error Message:
An unexpected exception occurred.
Error inesperado (archivo "", línea , función "").
The current operation was cancelled because another operation in the transaction failed.
An unexpected exception occurred.
Error inesperado (archivo "", línea , función "").

Stack Trace:
Microsoft.PowerBI.Modeler.ModelingASOperationException
en Microsoft.PowerBI.Modeler.TomExceptionExtensions.ThrowAsModelingASOperationException(Exception ex)
en Microsoft.PowerBI.Modeler.TomExtensions.ExecuteTomOperation(Action action)
en Microsoft.PowerBI.Modeler.ModelManager.InternalTransaction.<>c__DisplayClass22_0.<SaveChanges>b__0()
en Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingTelemetryService.<>c__DisplayClass10_0`1.<RunInActivity>b__0()
en Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingTelemetryService.RunInActivity(ModelingActivityKind activity, Action action)
en Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingTelemetryService.RunInActivity[T](ModelingActivityKind activity, Func`1 action)
en Microsoft.PowerBI.Modeler.ModelManager.InternalTransaction.SaveChanges(String description)
en Microsoft.PowerBI.Modeler.ModelManager.InternalTransaction.SaveChangesForCommit(String description, Boolean recalc)
en Microsoft.PowerBI.Modeler.ModelManager.InternalTransaction.Commit(Boolean recalc)
en Microsoft.PowerBI.Modeling.Engine.Authoring.AsyncModelAuthoringService.ModelAuthoringTransaction.Commit(RecalcBehavior recalcBehavior)
en Microsoft.PowerBI.Modeling.Engine.Loader.PowerQueryToModelLoader.ExecuteInTransaction(IExtendedModelChangeScope modelChangeScope, Func`1 action)
en Microsoft.PowerBI.Modeling.Engine.Loader.PowerQueryToModelLoader.<ApplyQueryChangesAndCreateRelationships>d__27.MoveNext()
--- Fin del seguimiento de la pila de la ubicación anterior donde se produjo la excepción ---
en System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
en Microsoft.PowerBI.Modeling.Engine.Loader.PowerQueryToModelLoader.<ApplyQueryChangesAndCreateRelationships>d__27.MoveNext()
--- Fin del seguimiento de la pila de la ubicación anterior donde se produjo la excepción ---
en System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
en System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
en Microsoft.PowerBI.Modeling.Engine.Loader.PowerQueryToModelLoader.<ProcessLoadInputs>d__25.MoveNext()
--- Fin del seguimiento de la pila de la ubicación anterior donde se produjo la excepción ---
en System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
en System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
en Microsoft.PowerBI.Modeling.Engine.Loader.PowerQueryToModelLoader.<>c__DisplayClass21_0.<<PerformLoadAsync>b__3>d.MoveNext()
--- Fin del seguimiento de la pila de la ubicación anterior donde se produjo la excepción ---
en System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
en Microsoft.PowerBI.Modeling.Engine.Loader.PowerQueryToModelLoader.<>c__DisplayClass21_0.<<PerformLoadAsync>b__3>d.MoveNext()
--- Fin del seguimiento de la pila de la ubicación anterior donde se produjo la excepción ---
en System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
en System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
en Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingTelemetryService.<>c__DisplayClass12_0`1.<<RunInAsyncActivity>b__0>d.MoveNext()
--- Fin del seguimiento de la pila de la ubicación anterior donde se produjo la excepción ---
en System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
en System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
en Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingTelemetryService.<RunInAsyncActivity>d__11.MoveNext()
--- Fin del seguimiento de la pila de la ubicación anterior donde se produjo la excepción ---
en System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
en System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
en Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingTelemetryService.<RunInAsyncActivity>d__12`1.MoveNext()
--- Fin del seguimiento de la pila de la ubicación anterior donde se produjo la excepción ---
en System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
en System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
en Microsoft.PowerBI.Modeling.Engine.Loader.LoadToReportFlow.<PerformLoadToAnalysisServices>d__15.MoveNext()
--- Fin del seguimiento de la pila de la ubicación anterior donde se produjo la excepción ---
en System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
en System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
en Microsoft.PowerBI.Modeling.Engine.Loader.LoadToReportFlow.<ExecuteInternal>d__10.MoveNext()
--- Fin del seguimiento de la pila de la ubicación anterior donde se produjo la excepción ---
en System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
en System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
en Microsoft.PowerBI.Modeling.Engine.Loader.LoadToReportFlow.<Execute>d__9.MoveNext()
--- Fin del seguimiento de la pila de la ubicación anterior donde se produjo la excepción ---
en System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
en System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
en Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingTelemetryService.<>c__DisplayClass12_0`1.<<RunInAsyncActivity>b__0>d.MoveNext()
--- Fin del seguimiento de la pila de la ubicación anterior donde se produjo la excepción ---
en System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
en System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
en Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingTelemetryService.<RunInAsyncActivity>d__11.MoveNext()
--- Fin del seguimiento de la pila de la ubicación anterior donde se produjo la excepción ---
en System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
en System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
en Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingTelemetryService.<RunInAsyncActivity>d__12`1.MoveNext()
--- Fin del seguimiento de la pila de la ubicación anterior donde se produjo la excepción ---
en System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
en System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
en Microsoft.PowerBI.Client.Windows.Modeling.Hosting.DesktopModelingHost.<>c__DisplayClass18_0.<<LoadToModel>b__1>d.MoveNext()
--- Fin del seguimiento de la pila de la ubicación anterior donde se produjo la excepción ---
en System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
en System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
en Microsoft.PowerBI.Modeling.Engine.Authoring.AsyncModelAuthoringService.<>c__DisplayClass10_0.<<RunExtendedModelChangeAsync>b__0>d.MoveNext()
--- Fin del seguimiento de la pila de la ubicación anterior donde se produjo la excepción ---
en System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
en Microsoft.PowerBI.Modeling.Engine.Authoring.AsyncModelAuthoringService.<>c__DisplayClass10_0.<<RunExtendedModelChangeAsync>b__0>d.MoveNext()
--- Fin del seguimiento de la pila de la ubicación anterior donde se produjo la excepción ---
en System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
en System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
en Microsoft.PowerBI.Modeling.Engine.Authoring.AsyncModelAuthoringService.<ContinueWithAsyncOperation>d__13.MoveNext()
--- Fin del seguimiento de la pila de la ubicación anterior donde se produjo la excepción ---
en System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
en System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
en Microsoft.PowerBI.Client.Windows.Modeling.Hosting.DesktopModelingHost.<LoadToModel>d__18.MoveNext()
--- Fin del seguimiento de la pila de la ubicación anterior donde se produjo la excepción ---
en System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
en System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
en Microsoft.PowerBI.Client.Windows.FloatingDialog.KoLoadToReportDialog.<>c__DisplayClass44_0.<<StartLoadToReportFlow>b__0>d.MoveNext()
--- Fin del seguimiento de la pila de la ubicación anterior donde se produjo la excepción ---
en System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
en System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
en Microsoft.Mashup.Client.UI.Shared.IExceptionHandlerExtensions.<HandleAwaitableAsyncExceptions>d__1.MoveNext()

Stack Trace Message:
An unexpected exception occurred.
Error inesperado (archivo "", línea , función "").
The current operation was cancelled because another operation in the transaction failed.
An unexpected exception occurred.
Error inesperado (archivo "", línea , función "").

[v-venuppu]

Hi @Joan_Roig ,

I hope this information is helpful.If this answers your question, please accept it as a solution,so other community members with similar problems can find a solution faster.

Thank you.

[v-venuppu · Accepted solution]

Hi @Joan_Roig ,

Thank you for your Response..!!

This happens when DAX tries to evaluate MAX() in a context where multiple values exist, and it can't determine which single value to use-especially when MAX() is used directly in a filter argument or inside CALCULATE.

Using a variable makes the logic stable and avoids ambiguity errors during evaluation.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly.

Thank you.

[v-venuppu]

Hi @Joan_Roig ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you

[Joan_Roig]

Hi @v-venuppu 

I'm still working on the issue.

I've resolved some measures that were using the MAX function by moving this function into a variable. I don't know why, but the MAX function within the DAX formula was causing an error, while using variables didn't

[v-venuppu]

Hi @Joan_Roig ,

I want to check whether if you are able to resolve the issue on your computer by following suggested steps.

If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-venuppu]

Hi @Joan_Roig ,

Glad to hear that its working instead of rebuilding it from the scratch.

1.Try rebooting your system once.

2.Try to install the same version in your computer with which you are able to work it on another computer.

3.If the issue still persists, please check with your IT Team why the issue is only on specific computer.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thank you.

[v-venuppu]

Hi @Joan_Roig ,

I recommend submitting your issue through Microsoft's official Support Ticket such as the Power Platform admin center.

Thank you.

[Joan_Roig]

I've opened the file on another computer without any errors. This is quite strange, as the issue seems to be specific to my computer when using this particular file, because I can open other pbix files correctly.

[v-venuppu]

Hi @Joan_Roig ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[Joan_Roig]

Hello, it's clear I can't solve this problem. The model has 80 measures, and using DAX View, I located three of them with the same error. I can't modify any measure because when the model tries to update, it fails again and doesn't save the changes.

I also opened the file with Tabular Editor and checked what was happening on the server with SQL Server Profiler. In both cases, errors appeared, but none of them clarified the actual problem. It's obvious this issue is beyond my current knowledge.

It looks like I'll have to rebuild the file from scratch, which will be a big job

[v-venuppu]

Hi @Joan_Roig ,

Yes, this is a common issue when the model can’t finish loading but you can still make changes without refreshing the entire model.

You can try with the below steps:

Open the PBIX file without triggering a refresh
1.Open the file in Power BI Desktop.

2.If it prompts you to refresh or apply pending changes, click “Discard” or “Cancel”.

3.Go straight to the Model View or Data View.

4.Delete or fix any recent measures, calculated columns, or relationships that might be causing issues.

5.Save the file and try refreshing again.

If that doesn’t help go with the following steps:
 1.Open a backup or make a copy of the file, then follow the same steps.

 2.In Power Query, disable most query loads so only one or two tables load at a time - this helps isolate which part is breaking the model.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thank you.

[v-venuppu]

Hi  ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @Jai-Rathinavel for the prompt response.

Here are some steps that can help to solve the issue:

Step 1: Check for errors in Power Query
Go to Home > Transform Data.

In the Power Query Editor, click on each table on the left.

Look for:

Any red or yellow error messages.

Any columns with “Error” values.

Fix or remove problem columns (like nulls in key columns or failed merge/expand).

If you merged another table, make sure it didn't introduce blank or invalid values.

Step 2: Clear Power BI Cache

Step 3: Remove or simplify relationships (if any)
Go to Model view.

Check if any table relationships have:

A dotted or inactive line.

Circular relationships.

Try deleting one or two complex relationships temporarily and reload.

Step 4: Load tables one at a time (to find the problem)
Save a copy of your file.

Disable load for all but one table:

Right-click a query in Power Query > “Enable load” (uncheck).

Try loading only one table.

Add tables back one at a time to find which one is breaking it.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thank you.

[Joan_Roig]

Hi,

I've tried to change or delete some measures, but the problem is that the model can't update, so the changes aren't applied.

I'm not sure how to make and save these changes.

Any ideas?

[Jai-Rathinavel]

Hi @Joan_Roig 

1. Please download the model from Service and refresh it on Desktop and Debug the error. 

2. Got to Power Query View and check individual queries for errors and fix it.