Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Not applicable

Database consistency checks (DBCC) failed while checking the...

Hi all as of January 1st i gett following message on dataset refresh on premium capacity:


The session was cancelled because it is connected to a database that is being evicted.
Database consistency checks (DBCC) failed while checking the data segments.
Database consistency checks (DBCC) failed while checking the '24b einkaufspreis (432170)' column.
Database consistency checks (DBCC) failed while checking the 'publisher cockpit (8151)' table.
Database consistency checks (DBCC) failed while checking the '705c4d8f-c1cb-44ea-a5f0-dcba6b7e98d4' database.
An error occurred while attempting to save the dataset (reference ID '705c4d8f-c1cb-44ea-a5f0-dcba6b7e98d4').
Database consistency checks (DBCC) failed while checking the segment statistics.


If i refresh dataset manually from PBI file, all works well

If i remove '24b einkaufspreis' column from dataset, then refresh will work from service again.

I checked '24b einkaufspreis' and there is really nothing wrong with it, it is decimal column coming from Amazon Redshift with precision of 3, and in PBI it is formatted as decimal as well.


Any ide where is this error coming from and how to solve it?

Regular Visitor

Hi all,


In my case, I reviewed the column that present this issue. This column was a new one using "XLockUp" function, so I added the function "IfError" and the issue gone.



Community Support
Community Support

Hi @Anonymous ,


Could you please try to verify if you are able to refresh dataset which only contain this Redshift data source in the same workspace ? Does this problem table has  relations with other tables such as using merge in power query?

If it is an urgent issue, We suggest you to open a ticket here for help if you are a pro user:

Best regards,


Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Not applicable

Hi @v-lid-msft 

I can refresh this exact same dataset in same workspace if i remove "24b - einkaufspreis" column, and there is nothing wrong with the column. It has the same data type as other columns coming from redshift. Only operation in Power Query is rename, there is no merge


Type in PBI is also decimal, so no confict there


In Data Load options like: Automaticaly detect column types, import relationship, autodetect new relationship are disabled.

I can try with creating a ticket but my experiences are not good so far, as MS support center will support in solving basic cases only as they are trained for 1st level support.




Hi, where you able to fix this issue? I'm getting the same error, the first refresh using the gateway works just fine and then it starts failing. Any help will be appreciated.

Not applicable

Hi @oscarmqz 

In my case all my attemps to fix it were unsuccessful, but after one week this problem disapeared. I assume there could be some internal fix from MS side.

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors