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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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