Auto Merge Tables - Monthly Update

[areias_br]

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"...

[ichavarria]

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]

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.