Adding only new data from separate txt-files to combined table

[ErikC]

Hi,

I have a number of .txt files that are loaded to Power BI to a combined table.

All files have identical columns. The filename is the same, except for the year:

Transactions 2000

Transactions 2001

....

Transactions 2019

How can i load data only from Transactions 2019 (current year) without reloading all previous years into

the combined table?

[d_gosbell]

---

@ErikC wrote:

How can i load data only from Transactions 2019 (current year) without reloading all previous years into

the combined table?

---

So this sort of functionality is known as incremental refresh. Unfortunately this functionality is only available at the moment on the Power BI Service in Premium Capacities see https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh

You can't do this in Power BI Desktop or with just a Pro license on a shared capacity on PowerBI.com