Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago

Refresh historical data + weekly

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.