Forum Discussion
razieh1990
Helper I
2 years agoDatamart and dataflow incremental refresh
Hello I am a SharePoint list as my data source and have established a dataflow to extract sales data from the past three years. Each day's data is stored in a separate Excel file, resulting in appro...
razieh1990
Helper I
2 years agoThanks for your response.
I pulled out data from sharepoint list and appended all of excel file and in dataflow and datamart.
The problem is that, when I applied the incremental refresh in dataflow it does not work.
but when I applied the incremental refresh it worked however the refresh time became longer than than normal refresh time.
johnbasha33
Super User
2 years agorazieh1990 that is expected to have longer refresh time, if you are not convinced, you can implement Azure AS model for faster executions.
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!