Forum Discussion

areias_br's avatar
areias_br
Icon for Helper I rankHelper I
3 years ago

Auto Merge Tables - Monthly Update

Hello,

Every month a department here in the company generates a table with some data I analyse in PBI. Then I neet to open PBI, merge the new table and so on.

Is there any way to auto-merge the tables? The tables are named: "Deviations - January", "Deviations - February"...

 

 

Need Help

2 Replies

  • ichavarria's avatar
    ichavarria
    Icon for Solution Specialist rankSolution Specialist
    3 years ago

    Hi areias_br,

     

    Where is this table stored? Is it an Excel file? You could consider saving the file in OneDrive and then create a direct connection from Power BI and use Power Query to merge, transform. This way you will not need to manually load it every time. 

     

    Best regards, 

    Isaac Chavarria

    If this post helps, then please consider Accepting it as the solution and give Kudos to help the other members find it more quickly

    • areias_br's avatar
      areias_br
      Icon for Helper I rankHelper I
      3 years ago

      There are several excel files in a folder in OneDrive. Every month they upload a new file in this folder. So today I have all data from "January" and "February" file. Next week I'll have to merge with the "March" file.