Database consistency checks (DBCC) failed while checking the column statistics

[manoj_0911]

Processing errorDatabase consistency checks (DBCC) failed while checking the column statistics. Database consistency checks (DBCC) failed while checking the '<oii>Column (8482)</oii>' column. Database consistency checks (DBCC) failed while checking the '<oii>AGENT SUBHOUR V (12)</oii>' table. Database consistency checks (DBCC) failed while checking the '6330c0aa-0781-4cce-ba3b-d4551318e4e7' database. Database consistency checks (DBCC) failed while checking the '' table. An error occurred while attempting to save the dataset (reference ID '6330c0aa-0781-4cce-ba3b-d4551318e4e7').
Cluster URIWABI-WEST-US-D-PRIMARY-redirect.analysis.windows.net
Activity ID034015b1-b76a-43c2-820d-035ca75caf6e
Request ID039985af-f9f0-5dc8-8ccb-b953b4c88923
Time2025-01-30 04:51:41Z

[divyed]

Hello @manoj_0911 ,

Kindly share more details like what are you trying to achieve and where (SQL, Power BI etc). Meanwhile you can try using repair option like below

DBCC CHECKDB ('YourDatabaseName', REPAIR_REBUILD);

If you are using power bi ,it likely means that there’s an issue either with the data model, the query execution, or the refresh process itself. Since Power BI relies on underlying data sources and uses queries (such as DAX or M queries) to pull data, these types of errors can indicate issues in data processing or an inconsistency in the model.

You can try few steps :

1. Refresh your dataset

2. Check query and data source to check inconsistant data,Complex dax or M queries and data source issue

3. Clear cache and retry

if your source is SQL try to update/rebuild statistics

UPDATE STATISTICS YourTableName; //for a single table

EXEC sp_updatestats;   //for entire dataabase

I hope this helps.