load the complete folder the first time, and after the update only the latest files

[Anonymous]

Hello,

I have a robot that saves data in a txt file inside a folder.

After a specific size of txt files (17579 Kb), the robot creates a new file (see image below).

When I update PowerBI, I want to view all the txt files in the folder.

But it takes a long time. It's as if PowerBI was updating the entire folder and forgot that it had already loaded a lot of data from the last update. For example, I open PowerBI in March and it loads the whole folder in blue (see image). But when I open PowerBI two weeks later, it loads the blue files again and finally the reds. I'd like it to remember all the blue txt files already loaded and only load the new red ones, so it doesn't take too long.

Do you have a simple example? Because I really don't understand what I read on the internet...

Thanks and sorry for my bad English

[lbendlin]

It's as if PowerBI was updating the entire folder and forgot that it had already loaded a lot of data from the last update.

That is correct. Power BI has no memory.  

There is an option to do Incremental Refresh but it requires quite a bit of plumbing.