Datamart Incremental refresh stuck on "Wrapping things up" and loading

[WRitchie]

Hi

When I try to apply incremtnal refresh to the GL table from Business central public cloud via API v2.0 I keep getting stuck on '"wrapping things up"

There is no error message generated.

When trying to acess the datamart after exitiing the below error is generated:

Activity ID: 61a2e1ed-109d-4435-9d73-b4439b11383d
Request ID: 9c55f941-b0f2-4efb-9e61-4390f15114f4
Correlation ID: 95eff954-d4ac-c7a0-878d-fe7c7ecb0b23
Status code: 400
Time: Tue Sep 06 2022 08:51:49 GMT+0200 (South Africa Standard Time)
Service version: 13.0.18945.52
Client version: 2208.4.12891-train
Cluster URI: https://wabi-west-europe-b-primary-redirect.analysis.windows.net/

[v-cazheng-msft]

Hi @WRitchie,

You mean your data source is Business Central? It seems like this kind of data source is not supported incremental refresh. Incremental refresh works best for structured, relational data sources, like SQL Database and Azure Synapse, but can also work for other data sources. In any case, your data source must support the following: Date column and Query folding. For more details, you could refer to Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Docs.

Best Regards,

Community Support Team _ Caiyun

[WRitchie]

@v-cazheng-msft thanks for the reponse

It seems to be upported as I have successfully used inremental refresh on the BC cusotmer table, which has ~40 000 rows, but it seems to fail for any larger table. The one in the OP has ~16 000 000 rows