Forum Discussion
Solved
Help with Model design from datasource Excel Spreadsheet with multiple tabs with same column layout
I need to create a PowerBI report The datasource is an Excel Spreadsheet The Excel spreadsheet is a in a central location all deparments can access to update the spreadsheet. The Excel sp...
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
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.