How to link multiple tables with same Column Headers

[Ab_Project]

Hello, 

I am new to power bi. My background tunneling projects. I have multiple excel files of project datas(200+). Each excel file has one tunneling project performance report table. All the tables in all the excel files have the same column headers, only all the rows values vary.

I was able to create one project summary dashboard for one project table in Bi desktop. However, I do not want to keep recreating a dashboard for every project table. My goal was just add all the project tables into Bi and filter the dashboard based on which project summary i want to view.

However, I cant seem to link all the project tables together and use a filter option to choose which project table summary I want to view on the dashboard.

Any advice on how i can approach this issue?

Thanks.

[94veiga]

You can append all the tables creating a new one with all the proyects toegther. For this, you should go to  QueryEditor and click on append. Then you choose the option three or more tables and select the ones you want to link.

[amitchandak · Accepted solution]

@Ab_Project , if all the excel are of the same format, you can add them and merge them. Hope each Excel as the project name.

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

or you can add a name from the sheet name

https://community.powerbi.com/t5/Desktop/Add-custom-column-with-sheet-name/m-p/877507