Link multiple tables

[A-J]

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.

[DataInsights · Accepted solution]

@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]

@A-J,

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