Refresh historical data + weekly

[Syndicate_Admin]

Greetings to all,

I've tried to look for something similar but can't find it on the forum.

My case starts with an excel file, for example until 20/11/23 since 2019, what I want is to increase the data as the weeks go by (weekly). I have the file in excel format, and that's what I want to upload to POWER BI.

I want to add the data and have it take data only from 11/21/23 to today and merge to the path where my dashboard is fed.

I've seen some of RangeStar and RangeEnd, but I don't think that's the problem that's happening to me.

The goal is to pass it on to the business area and for them, without much experience in this, to add the data from the 21st and automatically join through a pipeline that they create, because the data cleansing is already done.

Has anyone found themselves in the same situation who can help me?

Thank you very much in advance.

[Syndicate_Admin]

I mean change table ddbb_cleaned >> possibledata, it has both the same columns and values, how could I do it ?

Thank you

[lbendlin]

ingest all relevant files in that folder, then expand the columns which will automatically append the content.

[Syndicate_Admin]

I have already found the possible temporary solution, and that is to address everything to a local folder (until there is a source of data in the cloud), and add or remove as the months go by, the best thing is to delete one and put another in its place and so it updates itself.
What I don't know how to do is change all the charts from one table to another, without having to go one by one. Here is an example.

The structure of tables are the same, they have the same columns (name and number)

[lbendlin]

Very simple - use a folder connector instead of trying to connect to each file individually.

[lbendlin]

Power BI has no memory* . You need to manage your snapshots in the upstream system.

* Yes, there is the self referencing option but that has no safety net.