Forum Discussion

Dhruvsbhatt's avatar
Dhruvsbhatt
New Member
3 years ago

Add/Archive data to appended table

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

Data Protection

1 Reply

  • Kishore_KVN's avatar
    Kishore_KVN
    Solution Sage
    3 years ago

    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!!