Forum Discussion
incremental load
I am pulling 67 million records from an AS400/DB2 flat file. I break it up into 5 tables in my PBI. I would like to use incremental refresh, the question is if doing it by date, do I need to have the same date field in all five tables or will PBI refresh all the tables based on the date in the one table?
2 Replies
Hi Rsteinke,
I agree with mwegener's point of view, incremental load features may not fully works on data source that not support query folding. Perhaps you can add a T-SQL query(with query parameters) to your connector to limit the loading data range instead of configuring incremental refresh.
All You Need to Know About the Incremental Refresh in Power BI: Load Changes Only
Regards,Xiaoxin Sheng
