Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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 ?
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
57 | |
35 | |
27 | |
27 | |
26 |
User | Count |
---|---|
62 | |
51 | |
30 | |
24 | |
23 |