Table Relationships

[Anonymous]

Hello,

Currently building a Scorecard dashboard for different towers. My dataset is saved on Sharepoint list (already connected), now i have total of 9 tables (1 table for mapping, 1 table for date and 1 table to be my main table) so technically I have 6 tables (its 6 because it depends on their career lvl, lvl12-13, lvl11 so on) that was connected to Sharepoint list. I connect the mapping table to all 6 tables that was on the sharepoint list so i can use the mapping table for slicers like Employee name, their tower, their manager and their Business Head (Many(mapping) to Many(tables in sharepoint) cardinality). Since i want to put all 6 different tables on 1 table in visualizations, I created 1 table (blank but have all the columns) which im gonna use as main table so that i dont need to create 6 visualization tables  for different career levels but i ran into an error if i tried to connect all 6 tables to this 1 table i created which is Main Table that says "that would introduce ambiguity between tables CL12-13". Is it possible to connect all 6 tables (that was on sharepoint) and put it all in 1 table which is gonna my main table? Thanks in advance!

*Sheet1 is gonna be the Main Table

[bcdobbs · Accepted solution]

I think you'd be best using power query to append all the tables for each career level together. Create a new column on each called Career Level and assign a static value to each then use the append table function so they're all in one.

[Anonymous]

Hello! Sorry i dont know how to delete a thread. Actually i figured it all out, I did a Append Query on Power M and all 6 tables combine into 1 like magic! Anyway thanks for replying appreciate it!