Incremental refresh not works properly in powerbi service

[Maheshwari]

I have two datasource namely A & B both set to incremental refresh. In desktop,it works without any error.

In service,refresh fails with DBCC error for a calculated column(lookup value from table A)  in Table B. So i disabled incremental refresh for Table B. Then it refreshed without any error. But the tiles in report dashboard throws error for the same column. So disabled incremental refresh for Table A as well.Then everything worked fine.

Why incremental refresh have problem with lookup column. Is there any way to work incremental refresh fine in service also for the calculated column. Any help appreciated.

I already seen post related to DBCC error posted in 2020.Is it the same reason?

Solved: DBCC Error in Dataset refresh - Microsoft Power BI Community

[GilbertQ]

Hi @Maheshwari 

I would suggest creating the calculated column if possible in your data source?

That should solve your issue?

[Maheshwari]

Sorry I dont get you.I have already created a calculated column with lookup formula.

[GilbertQ]

Hi @Maheshwari 

What I meant was to not create the calculated column in your PBIX but create it in your data source?

[Maheshwari]

You mean in power query itself?