Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
ercetevlim
Regular Visitor

Error Opening PBIX file with PBI Desktop

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

 

4 REPLIES 4
v-yanjiang-msft
Community Support
Community Support

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

No, problem has continue

v-yanjiang-msft
Community Support
Community Support

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
Regular Visitor

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.