Forum Discussion

manoj_0911's avatar
manoj_0911
Kudo Commander
1 year ago

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

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

Need Help

1 Reply

  • divyed's avatar
    divyed
    Super User
    1 year ago

    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.