Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. 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 |
---|---|
49 | |
32 | |
27 | |
27 | |
26 |
User | Count |
---|---|
61 | |
56 | |
34 | |
29 | |
28 |