How does Refresh works in the case of Data spliting from on-premise SAP-BW to PowerBI?

[Anmolgan]

I have a report that contains 2 years of data, I fetched this by spliting the data into 4 different months and performed 6 Queries and appended the results. For example I know have data for the period of JULY 2017 till JULY 2019, now if I have to append the month of August I would have to manual append that particular month into the query right? 

But How does PowerBI refresh takes place if I want to perform a refresh for the current month every sunday of the appended month in the PowerBI?

[v-diye-msft]

Hi @Anmolgan ，

If you append the August data from another new table, once you refreshed the whole report in desktop, it will fetch the underlying source file, that is the August source table , as well as the previous source file. 

[Anmolgan]

How can this be setup on PowerBI Service side?