Forum Discussion
datamart 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...
I tried to implement incremental refresh on the dataflow, it did not work. I think this because SharePoint list as a data source isn't compatible with incremental refresh functionality.Any data source that has a DateTime column for the partition management will work. You may not gain much in terms of performance if the query doesn't fold.
What's the point of your datamart? Are you running SQL queries?
Worst case you can have dataflows for certain time periods (one per quarter, for example) and then union these in the semantic model.