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 ...
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.
