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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.