Consolidating training records to run reports

[TXNCPO]

Newbie (sort of) I've watch HOURS of video and even tried CHAT GPT, but I'm missing "something" I'm begging here.

I have 5 separate MS excel files, one for each of the employees. Each workbook had three "tabs" Core, Intermediate, and Advanced. I know (think) what I need to do in Power BI Desktop, is merge/append the data from all 15 (5 workbooks with three tabs) sources into one table/query? In my head this gives me the "nut" of information (the training names are unique across the three areas) to use a table/query of "AllTraining_Req" to produce reporting about what has been done and what needs to be done. I have played with DAX and feel like if I can get passed generating the "nut" of info, I can struggle bus from there. When I use "get data" from Folder, I am lost as to how to get ALL the completed training to show up, the Combine only seems tom pick up some of the data from the 5 workbook/three sheets. I really feel like i'm missing an easy step here, but after a week of trying to figure it out on my own. Guna have to set down the pride and ask for help. Thank you V/R Joe

 

[Matt Allington]

There’s no magic button you’re missing; it’s an advanced concept. I wrote this blog a few years ago that will help you. There’s lots of steps. Read it once then follow step by step. It assumes all sheets are structurally the same.

Combining Multiple Sheets from Multiple Workbooks

This article shows how to combine both sheets and workbooks together in Power Query using some tricks and advanced M language functions

exceleratorbi.com.au

 

[TXNCPO]

Sir, Thank you for your detailed response. I will provide any feedback after reviewing the You Tube and related comments (in case someone had the same question I did/will) I very much appreciate it. V/R Joe (guy who bites off more than he can chew sometimes, LOL)