Multiple workbooks

[Lscot6]

Hi have multiple workbooks with data one for each student and I want to build a dashboard that will bring this data together so I can see trends across a class and the school. 
each sheet has 271 rows and 70 columns with the same data and one column with student specific data. 

[Anonymous · Accepted solution]

Hi @Lscot6 ,

First of all, many thanks to for your very quick and effective replies, and I will give some additions below:

1.Create the three workbook and get the three Table.

2.Open the Power Query editor. Select the Append Queries in the Home pane.

3.Select three or more tables append.

4.Select Apply and close.

5.Create the report and publish to the service.

6.In the service, edit the report and pin to the dashboard.

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[_AAndrade]

Hi,
Take a look at this video:https://www.youtube.com/watch?v=-ZCsQ9K__yE