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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

DBCC Error on Non-existent Column

I am attempting to get incremental refresh working on a particular report and have repeatedly run into the error below:

 

Database consistency checks (DBCC) failed while checking the column statistics. Database consistency checks (DBCC) failed while checking the '<pii>Column (5640519)</pii>' column. Database consistency checks (DBCC) failed while checking the '<pii>mcat TireObject (4970)</pii>' table. Database consistency checks (DBCC) failed while checking the '9896d9d3-0813-48fa-8408-07a0d21296f7' database. An error occurred while attempting to save the dataset (reference ID '9896d9d3-0813-48fa-8408-07a0d21296f7').

 

Searching for answers has lead me to adding an additional DIM table to handle the columns with a large number of NULL and empty values (bug with IR handling large numbers of NULLS). I have the data types for each column set in the folding-enabled native query. I have recreated the problematic table in an attempt to remove any latent bugs. 

 

There is not a column named "Column (5640519)" in the table giving errors. That table has only 8 columns after relocating the two columns with a large number of blank/NULL values.

 

Any help is appreciated. Thanks!

3 REPLIES 3
Jean_123
New Member

Hello, I am having the same problem as you. I was wondering if you found a solution? Thanks!

Anonymous
Not applicable

There are no nulls in the date column. I did notice while checking that there were several calculated columns that were throwing errors. I deleted what was no longer relevant and corrected what still was. It's currently refreshing, I'll update when it is completed.

 

Update: Same error on upload, about 30 minutes into refresh.

lbendlin
Super User
Super User

Can you confirm that the column you use for the RangeStart/RangeEnd filter is free of Nulls ?

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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