Forum Discussion
Help with Model design from datasource Excel Spreadsheet with multiple tabs with same column layout
Hi
yes you can do it in Power query using the function Append.
Just be sure that all tables get same columns names and add on each table a column Dpt with the name of the dpt.
You will have everything in 1 table.
Hi dd88 ,
Step1: Add custom column "department" for each table.
Add a custom column - Power Query | Microsoft Learn
Step2: Append tables.
Append queries - Power Query | Microsoft Learn
Best Regards,
Jay
Hi dd88 ,
Step1: Add custom column "department" for each table.
Add a custom column - Power Query | Microsoft Learn
Step2: Append tables.
Append queries - Power Query | Microsoft Learn
Best Regards,
Jay
Thank you all, thats great.
Append workd.
With the Append, I now have 1 table containing all data. I still have the other 6 seperate tables, What do I do with the other 6 tables? delete the tables. I noticed my PowerBi desktop is starting to get slow in performance.
TIA
