Hi. I am hoping this is doable. Multiple tables all have the same structure with a column name that matches the "master" table. I can create a relationship one at a time in PowerPivot. But is there a way to link all the tables to the master table in one step? This would save a lot of time. I have not been able to find the answer to this.

Perhaps there is a relationship detection feature that can be used in this case, but every time I try to auto-detect, it never finds relationships even though the column name is matching. I am using Office 2016, but can also test in 2010 if this feature can be found there but not in 2016.

Thanks!