The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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!
Hello, I am having the same problem as you. I was wondering if you found a solution? Thanks!
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.
Can you confirm that the column you use for the RangeStart/RangeEnd filter is free of Nulls ?