Forum Discussion

Bokazoit's avatar
Bokazoit
Icon for Continued Contributor rankContinued 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
Icon for Community Support rankCommunity Support
1 year ago

Hi Bokazoit 

I wanted to check if you’ve had a chance to review the information provided. If you have any further questions, please let us know. Has your issue been resolved? If not, please share more details so we can assist you further.

Thank You.

Bokazoit's avatar
Bokazoit
Icon for Continued Contributor rankContinued 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
    Icon for Community Support rankCommunity Support
    1 year ago

    Hi ,

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

    • Bokazoit's avatar
      Bokazoit
      Icon for Continued Contributor rankContinued Contributor
      1 year ago

      Well it timed out again even with PPU 😞

      • v-karpurapud's avatar
        v-karpurapud
        Icon for Community Support rankCommunity Support
        1 year 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.