Unable to open pbix file

[martinrowe80]

hello

strange issue. Im not able to open the pbxi file, error message below

Feedback Type:
Frown (Error)

Error Message:
Database consistency checks (DBCC) failed while checking the '[Hierarchy for column Transaction History ID (211)]' hierarchy.
Database consistency checks (DBCC) failed while checking the 'Transaction History ID (211)' column.
Database consistency checks (DBCC) failed while checking the 'Transaction History (19)' table.
Database consistency checks (DBCC) failed while checking the '7498aae9-3352-4c6b-8ac0-72a765525ba7' database.

I have a previous version of the file I can redo my work in, however there is some useful work which I have done in this version of the file, which I would very much like to get back from this file which now seems to have this problem. After I completed my changes in this now corrupted file I was able to complete the refresh and save the file ok. Now on opening it throws this error!

[v-easonf-msft]

Hi， @martinrowe80 

If the report data source is Multidimensional and Tabular databases on an Analysis Services instance, please check if the below thread could help.

Database Consistency Checker (DBCC) for Analysis Services 

Best Regards,
Community Support Team _ Eason

[martinrowe80]

full stack trace in error message;

Feedback Type:
Frown (Error)

Error Message:
Database consistency checks (DBCC) failed while checking the '[Hierarchy for column Transaction History ID (211)]' hierarchy.
Database consistency checks (DBCC) failed while checking the 'Transaction History ID (211)' column.
Database consistency checks (DBCC) failed while checking the 'Transaction History (19)' table.
Database consistency checks (DBCC) failed while checking the '7498aae9-3352-4c6b-8ac0-72a765525ba7' database.

Stack Trace:
Microsoft.AnalysisServices.OperationException
at Microsoft.PowerBI.Client.Windows.Storage.FileOpenError.HandleError(IWindowService windowService, LocalizedString title)
at Microsoft.PowerBI.Client.Program.TryOpenOrCreateReport(IPowerBIWindowService windowService, IFileManager fileManager, IFileHistoryManager fileHistoryManager, String filePath, FileType fileType, IFileInformationProtectionManager fileInformationProtectionManager, IPowerBITelemetryService telemetryService)
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)

Stack Trace Message:
Database consistency checks (DBCC) failed while checking the '[Hierarchy for column Transaction History ID (211)]' hierarchy.
Database consistency checks (DBCC) failed while checking the 'Transaction History ID (211)' column.
Database consistency checks (DBCC) failed while checking the 'Transaction History (19)' table.
Database consistency checks (DBCC) failed while checking the '7498aae9-3352-4c6b-8ac0-72a765525ba7' database.

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.PowerBI.Client.PowerBIUnexpectedExceptionHandler.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.108.997.0","ModuleName":"Microsoft.PowerBI.Client.Windows.dll","Component":"Microsoft.PowerBI.Client.Windows.Storage.FileOpenError","Error":"Microsoft.AnalysisServices.OperationException - PFE_XM_DBCC_HIERARCHY_FAILED,PFE_XM_DBCC_COLUMN_FAILED,PFE_XM_DBCC_TABLE_FAILED,PFE_XM_DBCC_DATABASE_FAILED","MethodDef":"HandleError - PFE_XM_DBCC_HIERARCHY_FAILED,PFE_XM_DBCC_COLUMN_FAILED,PFE_XM_DBCC_TABLE_FAILED,PFE_XM_DBCC_DATABASE_FAILED","ErrorOffset":"201"}

PowerBINonFatalError_ErrorDescription:
PFE_XM_DBCC_HIERARCHY_FAILED,PFE_XM_DBCC_COLUMN_FAILED,PFE_XM_DBCC_TABLE_FAILED,PFE_XM_DBCC_DATABASE_FAILED

PowerBINonFatalError_MethodDefDescription:
PFE_XM_DBCC_HIERARCHY_FAILED,PFE_XM_DBCC_COLUMN_FAILED,PFE_XM_DBCC_TABLE_FAILED,PFE_XM_DBCC_DATABASE_FAILED

PowerBIUserFeedbackServices_IsReported:
True