Add/Archive data to appended table

[Dhruvsbhatt]

Hi I have a problem

We have power Bi model with 1 table that brings current month values from excel file(auto published to shared network drive from sap business object) on a refresh. We want to append those values on to a different table but on every refresh we want to add values and accumulate on appended table. How do I accomplish this is PowerBI desktop

[Kishore_KVN]

There is no way in Power BI that you automatically append data but the alternate to it is, get that excel data into a folder and connect to that folder directly from Power BI. So that whenever new file is added in that folder, Power BI will also append it while refreshing. 

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!