Forum Discussion
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,...
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.
Hi Bokazoit ,
Is it possible to load data into a database? You can use database as staging area and dbs support query folding.
Loading data into database is best practice but if you use Fabric, you can ingest data with Dataflow Gen2.
After that you can write results into Lakehouse table and build your model on top of the lakehouse.
If this solved your issue, please mark it as the accepted solution. ✅