There are multiple places in our organization that would benefit from a folder-style import that only refreshes the latest file in the folder, then appends that data to an existing table. We have a separate business intelligence software that we use to run reports and export data via Excel. We then reference the xlsx files for various BI reports. Basically, we could use a refresh which only appends new data (the latest xlsx export), but doesn't refresh existing data.
2 Comments
- I would like to generalize the solution to a plain "incremental refresh append mode" that is available also for other sources: web, dataflow, etc., not only file. The behavior should be: Whenever I refresh the data source (manually or scheduled), the new data is appended to the existing data in Power BI Service. Use case is all secenarios where the source provides daily (or monthly etc.) data, but not the history, whereas in Power BI I need the history. It's up to the user to implement a reasonable refresh schedule so that no duplicates or gaps are created in the data in Power BI, but that's already doable with existing Power BI instruments.
- Status added:Needs Votes
