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
Bokazoit's avatar
Bokazoit
Continued Contributor
1 year ago

I am doing my best, but I just don't get a PPU lincens. So I will return asap

v-karpurapud's avatar
v-karpurapud
Community Support
1 year ago

Hi ,

Thank you for the update. Looking forward to your response.

  • Bokazoit's avatar
    Bokazoit
    Continued Contributor
    11 months ago

    Well it timed out again even with PPU 😞

    • 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.