Forum Discussion

A-J's avatar
A-J
New Member
3 years ago
Solved

Link multiple tables

Hello,

 

New to PowerBi so your help is appreciated.

 

I have 8 different tables, the data in each varies and with all the column headers in each table being identical.

 

I am trying to create a visual that will display data from all these tables.

 

Eg. A visual which will count the all the data in total hours column from each table (8 tables) and display this as a sum of these in a visual.

  • A-J,

     

    In Power Query, click "Append Queries as New":

     

     

    Choose "Three or more tables", and add each table to the "Tables to append" section:

     

     

2 Replies

  • A-J,

     

    In Power Query, click "Append Queries as New":

     

     

    Choose "Three or more tables", and add each table to the "Tables to append" section:

     

     

    • DataInsights's avatar
      DataInsights
      Super User

      A-J,

       

      Be sure to disable load for the 8 individual tables. This will prevent them from being loaded into the model.