Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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

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/

Status: Investigating

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

Comments
v-cazheng-msft
Community Support
Status changed to: Investigating

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
Regular Visitor

@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