Power Query Extension

[EricS123]

Hi, Im currently working on improving a speadsheet my work has keeping track of parts that are made and used. To sum it up, we have a long list of every part made and a second list of every part that's been used, with a chart beside keeping track of totals and whats left in stock .

With multiple people constantly adding to this list, I was looking for a way for them to add to this list without them having to scroll all the way to the bottom of the 200+ entries just to say they made 20 metal arms.

From what I've seen in my research, a power Query is the best way to go about this, but I dont see much on how to add to them without making a whole other table.

Any tips as to how I could just add rows to the bottom of the table without having to scroll all the way down would be incredibly helpful.

[Anonymous · Accepted solution]

Hi @EricS123 ,

You can create a separate table for new entries and put them in a folder. 

Then Get Data --> From file --> From folder --> select the folder --> transform and combine.

When a new excel file is available in the back folder, it will automatically append the contents to the table, you just need to make sure the field names/metadata are consistent.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum