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.

v-hjannapu's avatar
v-hjannapu
Community Support
7 months ago

Hi Bokazoit,
Thank you  for reaching out to the Microsoft fabric community forum.

Incremental refresh works only when Power BI can push filters back to the source (query folding). When the data is downloaded as a ZIP file and then unzipped in Power Query, that folding is lost. Because of this, incremental refresh will not work in this scenario.

Even if you use Power Automate or any other flow to download and unzip the file, Power BI will still treat it as a file-based source, so incremental refresh is not supported there.

If incremental refresh is mandatory, the data needs to come from a source that supports folding, like a database or an API where you can filter data by date. Otherwise, a full refresh is the only option with ZIP files.

Kindly refer to the below documentation links for better understanding:
https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview

Hope the above provided information help you resolve the issue, if you have any further concerns or queries, please feel free to reach out to us.
Best Regards,
Community Support Team.