Forum Discussion

Lscot6's avatar
Lscot6
New Member
2 years ago
Solved

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 ro...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

     

     

     

     

     

     

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.