Cannot open the report anymore

[Anonymous]

Hi, I need a help pls. I was working on a report without any problems in my VM.

After a change I've done the report was closed and I'm not able to open it anymore in my VM. It says that something went wrong and there is a column that cannot be determined. That column was created at the beginning and I deleted 1 week ago and I refreshed and it was working. I don't know what is happening?

Also, I've tried to open the report from a remote desktop and it works.

Thanks

That's the error.

Feedback Type:
Frown (Error)

Error Message:
Failed to save modifications to the server. Error returned: 'The value for 'NumOfBreakChanges' cannot be determined. Either the column doesn't exist, or there is no current row for this column.
Cannot convert value '{2544B301-4602-4182-5421-08D7DB00A75E}' of type Text to type Integer while processing column - ServiceUser[Id] -> AuditPractitionerQuery[ServiceUserId].
'.

Stack Trace:
at Microsoft.AnalysisServices.Tabular.Model.SaveChangesImpl(SaveOptions options)
at Microsoft.PowerBI.Modeler.ModelManager.<SaveChanges>b__214_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.Modeler.ModelManager.SaveChanges(String description)
at Microsoft.PowerBI.Modeler.ModelManager.InternalTransaction.Commit(Boolean recalc)
at Microsoft.PowerBI.Modeling.Engine.Authoring.AsyncModelAuthoringService.ModelAuthoringTransaction.<>c__DisplayClass17_0.<Commit>b__0()
at Microsoft.PowerBI.Modeling.Engine.Authoring.ModelAuthoringExceptionHandler.AddModelChangeResultToExceptions(Action action, ModelChangeResult modelChangeResult)
at Microsoft.PowerBI.Modeling.Engine.Authoring.AsyncModelAuthoringService.ModelAuthoringTransaction.Commit(RecalcBehavior recalcBehavior)
at Microsoft.PowerBI.Client.Windows.ReportPreparer.<>c.<PerformRecalc>b__22_0(IExtendedModelChangeScope scope)
at Microsoft.PowerBI.Modeling.Engine.Authoring.AsyncModelAuthoringService.RunOutOfBandExtendedModelChange(Action`1 extendedModelChange, IDataModel dataModel, IModelManager modelManager, Boolean roleChangesImpactQueries, IRefreshPolicyUpdater refreshPolicyUpdater, Boolean skipDataModelTracing)
at Microsoft.PowerBI.Modeling.Engine.ModelingEngine.RunOutOfBandExtendedModelChange(Action`1 extendedModelChange, IDataModel dataModel, IModelManager modelManager, Boolean roleChangesImpactQueries, IRefreshPolicyUpdater refreshPolicyUpdater)
at Microsoft.PowerBI.Client.Windows.AnalysisServices.AnalysisServicesDatabaseLocal.RunOutOfBandExtendedModelChange(Action`1 extendedModelChange, IRefreshPolicyUpdater refreshPolicyUpdater, Boolean requireASDBToBeUnattached)
at Microsoft.PowerBI.Client.Windows.ReportPreparer.PerformRecalc(Report report, IPowerBIWindowService windowService)
at Microsoft.PowerBI.Client.Windows.ReportPreparer.Prepare(Report report, PackageValidationResult mashupResult, IPowerBIWindowService windowService, String fileName, ILuciaFeatureSwitchProxy luciaFeatureSwitchProxy, Nullable`1 entryPoint, Version pbixFileVersion)
at Microsoft.PowerBI.Client.Windows.Services.PowerBIPackagingService.Open(FileStream fileStream, IPowerBIWindowService windowService, Nullable`1 entryPoint, PowerBIPackageOpenOptions options, ReportPreparerResult& prepareResult)
at Microsoft.PowerBI.Client.Windows.Services.FileManager.<LoadFromPbix>d__20.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__DisplayClass15_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(Task 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(IUIHost uiHost, ISplashScreen splashScreen, IFileManager fileManager, IFileHistoryManager fileHistoryManager, String filePath, FileType fileType)
at Microsoft.PowerBI.Client.Program.<>c__DisplayClass1_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)

Stack Trace Message:
Failed to save modifications to the server. Error returned: 'The value for 'NumOfBreakChanges' cannot be determined. Either the column doesn't exist, or there is no current row for this column.
Cannot convert value '{2544B301-4602-4182-5421-08D7DB00A75E}' of type Text to type Integer while processing column - ServiceUser[Id] -> AuditPractitionerQuery[ServiceUserId].
'.

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.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
at Microsoft.PowerBI.Client.Program.Main(String[] args)

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.84.701.0","ModuleName":"Microsoft.PowerBI.Tabular.dll","Component":"Microsoft.AnalysisServices.Tabular.Model","Error":"Microsoft.AnalysisServices.OperationException","MethodDef":"SaveChangesImpl - PFE_XM_COL_DATA_TYPE_MISMATCH","ErrorOffset":"0"}

PowerBINonFatalError_MethodDefDescription:
PFE_XM_COL_DATA_TYPE_MISMATCH

ModelChangeResult:
{"changes":[],"hasQueryImpact":false}

[edhans]

Are you using a live connect @Anonymous - there is an issue here logged, but there have been 2 releases since the initial release and this should be fixed. I am currently on 2.84.701.0, which was released either Saturday or Sunday (yesterday). Try that, and review that thread.

[Anonymous]

Thanks for replying.

I reinstall powerBI in my VM but is still not working. A colleague couldn't open the file because the version he had but once he update the version he could open the report.

I'm still working on the remote machine as it hasn't been updated.

Thanks

Marcela

[Anonymous]

Finally, it works.

I've downloaded from the site instead and installed it again.

Thanks for your help.

MM

[edhans · Accepted solution]

Thanks @Anonymous  - please mark my answer as the solution so this thread can be shown to be closed and may assist others that have the same issue.

[Anonymous]

One more thing...I installed power Bi desktop using windows store. Maybe that's the issue? I'm going to try to download it from the site and install it again.

[edhans]

The Windows Store version is what I am using. But yes, if it is giving you issues, try the download. The core program though is the same. The nice thing about the store version is it is generally always up to date. That is why I know two releases have happened since the big Aug 2020 release. (At least two - could have been more that I didn't see)

Also, maybe I missed it @Anonymous but what kind of report is it? LIve Connect (SSAS/Power BI Dataset), Direct Query, Import, Composite?

The issue reported was SSAS/Live Connect/Power BI Datatset. But I can confirm the latest Windows Store version doesn't have this issue.

[amitchandak]

@Anonymous , Log an issue. There is already some known issue from August 2020 release, check those

Check https://community.powerbi.com/t5/Issues/idb-p/Issues