Error Opening PBIX file with PBI Desktop

[ercetevlim]

Hello everyone,

I get the following error when I try to open my PBIX file.  How can i fix this error?

Database consistency checks (DBCC) failed while checking the '[Hierarchy for column Çağrı Tarihi (12192)]' hierarchy.
Database consistency checks (DBCC) failed while checking the 'Çağrı Tarihi (12192)' column.
Database consistency checks (DBCC) failed while checking the 'xView db2 102 CDR (12157)' table.
Database consistency checks (DBCC) failed while checking the '998c563a-5816-4dfb-854f-465d7c857c46' database.


PFE_XM_DBCC_HIERARCHY_FAILED,PFE_XM_DBCC_COLUMN_FAILED,PFE_XM_DBCC_TABLE_FAILED,PFE_XM_DBCC_DATABASE_FAILED

PFE_XM_DBCC_HIERARCHY_FAILED,PFE_XM_DBCC_COLUMN_FAILED,PFE_XM_DBCC_TABLE_FAILED,PFE_XM_DBCC_DATABASE_FAILED

True

Feedback Type:
Frown (Error)

Timestamp:
2023-06-05T10:56:20.2927354Z

Local Time:
2023-06-05T13:56:20.2927354+03:00

Session ID:
878baf3e-f8a1-401a-8822-e98cfaa5d48f

Release:
May 2023

Product Version:
2.117.984.0 (23.05) (x64)

Stack Trace:
Microsoft.AnalysisServices.OperationException
konum: Microsoft.PowerBI.Client.Windows.Storage.FileOpenError.HandleError(IWindowService windowService, LocalizedString title)
konum: Microsoft.PowerBI.Client.Program.TryOpenOrCreateReport(IPowerBIWindowService windowService, ICurrentFileManager currentFileManager, IFileHistoryManager fileHistoryManager, CommandLine commandLine, FileType fileType, IFileInformationProtectionManager fileInformationProtectionManager, IPowerBITelemetryService telemetryService)
konum: Microsoft.PowerBI.Client.Program.<>c__DisplayClass6_0.<RunApplication>b__0()
konum: Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass3_0.<HandleExceptionsWithNestedTasks>b__0()
konum: Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.117.984.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":"255"}

OS Version:
Microsoft Windows NT 10.0.19045.0 (x64 tr-TR)

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

Peak Virtual Memory:
69.6 GB

Private Memory:
229 MB

Peak Working Set:
469 MB

IE Version:
11.789.19041.0

User ID:
592ece83-446b-4a1a-ac85-36103e6aab91

Telemetry Enabled:
True

DPI Scale:
125%

Supported Services:
Power BI

[v-yanjiang-msft]

Hi @ercetevlim ,

Is your problem resolved? If so, please accept the helpful reply as solution, then we will close the thread, others who has the same problem will benefit here.

Best regards,

Community Support Team_yanjiang

[ercetevlim]

No, problem has continue

[v-yanjiang-msft]

Hi @ercetevlim ,

By my research, you can try the methods mentioned in the below post:

Troubleshoot database consistency errors reported - SQL Server | Microsoft Learn

How to Troubleshoot Database Consistency Errors reported by DBCC CHECKDB? - SQL Server Forum - Spice...

Database consistency checks (DBCC) failed whil... - Microsoft Fabric Community

Best Regards,
Community Support Team _ kalyj

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

[ercetevlim]

Feedback Type:
Frown (Error)

Error Message:
Database consistency checks (DBCC) failed while checking the '[Hierarchy for column Çağrı Tarihi (12192)]' hierarchy.
Database consistency checks (DBCC) failed while checking the 'Çağrı Tarihi (12192)' column.
Database consistency checks (DBCC) failed while checking the 'xView db2 102 CDR (12157)' table.
Database consistency checks (DBCC) failed while checking the 'a86ff904-7ee3-457a-938e-4379a62f1a77' database.

Stack Trace:
Microsoft.AnalysisServices.OperationException
konum: Microsoft.PowerBI.Client.Windows.Storage.FileOpenError.HandleError(IWindowService windowService, LocalizedString title)
konum: Microsoft.PowerBI.Client.Program.TryOpenOrCreateReport(IPowerBIWindowService windowService, ICurrentFileManager currentFileManager, IFileHistoryManager fileHistoryManager, CommandLine commandLine, FileType fileType, IFileInformationProtectionManager fileInformationProtectionManager, IPowerBITelemetryService telemetryService)
konum: Microsoft.PowerBI.Client.Program.<>c_DisplayClass6_0.<RunApplication>b_0()
konum: Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c_DisplayClass3_0.<HandleExceptionsWithNestedTasks>b_0()
konum: Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

Stack Trace Message:
Database consistency checks (DBCC) failed while checking the '[Hierarchy for column Çağrı Tarihi (12192)]' hierarchy.
Database consistency checks (DBCC) failed while checking the 'Çağrı Tarihi (12192)' column.
Database consistency checks (DBCC) failed while checking the 'xView db2 102 CDR (12157)' table.
Database consistency checks (DBCC) failed while checking the 'a86ff904-7ee3-457a-938e-4379a62f1a77' database.

Invocation Stack Trace:
konum: Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
konum: Microsoft.Mashup.Client.UI.Shared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace, String exceptionMessage)
konum: Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.GetStackTraceInfo(Exception e)
konum: Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture)
konum: Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c_DisplayClass14_0.<HandleException>b_0()
konum: Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)
konum: Microsoft.PowerBI.Client.PowerBIUnexpectedExceptionHandler.HandleException(Exception e)
konum: Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
konum: Microsoft.PowerBI.Client.Program.RunApplication(String[] args)
konum: Microsoft.PowerBI.Client.Program.Main(String[] args)

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.117.984.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":"255"}

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