DBCC Error in Dataset refresh

[Anonymous]

Hi,

I'm getting the following errors when refreshing a Dataset.

Database consistency checks (DBCC) failed while checking the segment statistics. Database consistency checks (DBCC) failed while checking the data segments. Database consistency checks (DBCC) failed while checking the 'PaintCostAmount (226)' column. Database consistency checks (DBCC) failed while checking the 'VehicleSales Vehicles (31)' table. Database consistency checks (DBCC) failed while checking the '85ebc017-b957-45f2-9425-ba405c904d27' database. An error occurred while attempting to save the dataset (reference ID '85ebc017-b957-45f2-9425-ba405c904d27').

I've run DBCC CHECKDB without errros.

The report runs correctly in Desktop.

November 2020 version of the Gateway (didn't fix it)

Same on both powerBI.com and also dedicated capacity.

Report runs fine against another DB with identical schemas.

Any ideas, or where to look next?

[Anonymous]

Just an FYI for this issue.

The table in question has incremental refresh set to keep 37 months, update 37 months if updateddatetime field changes.

If I turn off incremental refresh for this table, the report updates without issue.

I had a feeling it was due to implementing incremental refresh.

Still njo fix, but I see December's version of the gateway is out, so might try that.

[Anonymous · Accepted solution]

Micorsoft have confirmed this as a bug. Incremental refresh fails but full refresh works. There is a problem with too many NULL values in the reported column.

They said it will be corrected in a newer version.

Hope this helps others.

[Anonymous]

Hello, I don't have a solution yet but I did just encounter this issue last evening suddenly.  I published successfully then made one more change and subsequently received internal server errors.  I will submit ticket and share any results here.

[Anonymous]

Hi, I'm still looking for a solutions for this issue. Can you shed any light on your findings yet?