Forum Discussion
Multiple workbooks
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.
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.
2 Replies
Hi,
Take a look at this video:https://www.youtube.com/watch?v=-ZCsQ9K__yEHi 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.
