Forum Discussion
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
- DataInsightsSuper User
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:
- DataInsightsSuper User
A-J,
Be sure to disable load for the 8 individual tables. This will prevent them from being loaded into the model.