corrupted file

[Hayan]

after working a few hours, my power BI file refuses to open, nothing found in the auto save folder, please help

We weren't able to restore the saved database to the model.

PFE_XM_DBCC_HIERARCHY_FAILED,PFE_XM_DBCC_COLUMN_FAILED,PFE_XM_DBCC_TABLE_FAILED,PFE_XM_DBCC_DATABASE_FAILED

True

ExecuteXmla failed with result

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.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)

PFE_XM_DBCC_HIERARCHY_FAILED,PFE_XM_DBCC_COLUMN_FAILED,PFE_XM_DBCC_TABLE_FAILED,PFE_XM_DBCC_DATABASE_FAILED

Database consistency checks (DBCC) failed while checking the '[Hierarchy for column ID (42466)]' hierarchy.
Database consistency checks (DBCC) failed while checking the 'ID (42466)' column.
Database consistency checks (DBCC) failed while checking the 'AggInvoice (42447)' table.
Database consistency checks (DBCC) failed while checking the 'e9747f2f-5740-4afa-9c9b-87d87ea7f3ca' database.

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.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)

[Anonymous]

Hi @Hayan ,

Refer to these two methods，maybe it will work

1.Roll back the version.

2.Change some configuration about the documentation

For more you may refer to：

Unable to open document; we weren't able to restore saved database to the model 

Unable to open the document issue 

Best Regards,
Community Support Team _ Caitlyn

[ugurdemir]

It's about a month or two i'm having this problem so frequently. Like 1 or 2 times a week. Losing my effort on report and must roll back to a backup file. A frustration on Microsoft side.

If we think i'm a powerbi developer spending more then 20 hours a week on powerbi, this problem should be related about the version.