WRitchie's avatar
WRitchie
Regular Visitor
4 years ago
Status:
Investigating

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/

Data Modeling

2 Comments

  • v-cazheng-msft's avatar
    v-cazheng-msft
    Icon for Community Support rankCommunity Support
    4 years ago
    Status changed:
    New
    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's avatar
    WRitchie
    Regular Visitor
    4 years ago

    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

Completed Ideas