Forum Discussion

Bokazoit's avatar
Bokazoit
Continued Contributor
7 months ago
Solved

Incremental refresh from API as zip file possible?

I can retrieve the data as a zip file, unpack it and load it into a table in Power BI desktop, but how to add incremental refresh? CoPilot says that retrieving data as zip file removes query folding,...
Need Help
  • v-hjannapu's avatar
    v-hjannapu
    7 months ago

    Hi Bokazoit,
    I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.

    Regards,
    Community Support Team.

sarahlns's avatar
sarahlns
Frequent Visitor
7 months ago

Hi 

No, incremental refresh is not supported when loading data from an API that returns a ZIP file directly in Power BI.

Incremental refresh requires query folding. Downloading and unzipping files in Power Query breaks folding, so date filters (RangeStart / RangeEnd) can’t be pushed to the source.

Recommended approach:
Move the ingestion upstream:

  • Use Fabric Data Pipelines / ADF / Logic Apps to call the API

  • Store & unzip the data in OneLake / ADLS

  • Load into a Lakehouse or Warehouse

  • Enable incremental refresh on that table in Power BI

This is the supported and scalable pattern in Fabric.