Data Model Table Relationships

[Akthad]

I have a table that has a primary key that is common in several other tables. The "WBS" table has the primary key of "WBS Code" which is related to a WBS foreign key in many other tables (Estimates, commitments, Time Phased Data, progress, etc...)

I having trouble getting the model to see the related tables. It seems that the Excel Data Model wants a single relationship between two tables. My data is more of a spoke and hub type relationship.

Any thoughts or ideas on how to work around this issue?

Thad

 

[Matt Allington]

Have a read of my article here Relationships in Power BI and Power Pivot - Excelerator BI

 

[Akthad]

Have a read of my article here Relationships in Power BI and Power Pivot - Excelerator BI

Thanks, Matt. I'm printing the article and going back to look at my structure. This article is helpful, I'm used to doing things in MS Access and I'm finding some differences.