Forum Discussion

Bokazoit's avatar
Bokazoit
Continued Contributor
1 year ago

Handle "large" amount of data using API and incremental refresh

I write "large" because the intial load is 3.5 mio rows, and that is imho not large. But my problem is this:   It is Business Central and I fetch data using API.   I would like to use incremental...
Need Help
v-karpurapud's avatar
v-karpurapud
Community Support
11 months ago

Hi Bokazoit 

Thank you for testing this with PPU. Since the refresh is still timing out in that environment, it seems the issue may not be just about capacity, but could also be related to how the Business Central API handles the query. We recommend submitting a support ticket to Microsoft so they can check the service-side refresh logs and see if the issue is due to query folding, API throttling, or another platform limitation.

You can use the following link to create a Microsoft Support ticket:

How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

Regards,
Microsoft Fabric Community Support Team.

v-karpurapud's avatar
v-karpurapud
Community Support
11 months ago

Hi Bokazoit 

We are following up once again regarding your query. Could you please confirm if the issue has been resolved through the support ticket with Microsoft? If the issue has been resolved, we kindly request you to share the resolution or key insights here to help others in the community.

Regards,
Microsoft Fabric Community Support Team.

  • Bokazoit's avatar
    Bokazoit
    Continued Contributor
    11 months ago

    I am currently testing it, and have been testing some different methods. If this last trial does not work I will create a support ticket.

     

    So it is not resolved yet

    • v-karpurapud's avatar
      v-karpurapud
      Community Support
      11 months ago

      Hi, 

      Thanks for the update. Please let us know your results.