Schema Issues

[rgadbois]

Hi,

I am attempting to re-organize my schema/relationships as I have been continually adding more and more tables. I have developed a Sports Performance database in which all pieces of technology we use are linked into one PowerBI file to look at all players at all times.

I began with one Fact Table, "Player Information", with all different exports from technologies being dimension tables. The more I utilize and understand PowerBI, each new dimension table has become a sort of a fact table, with different names, dates, and metrics based on the piece of technology. As I am trying to have one main calculated "Date" table which provides me flexibility with each date and maneuvring data, I cannot link all tables across to other tables as now there are conflicts. Attached is a photo of my current schema. Any assistance for best practices for this layout would be greatly appreciated. 

P.S. I have considered exporting all information into one large table, but considered this would not be the best course of action as I would have a table with 100+ columns.

P.P.S One table's name is blocked out due to title security with this information.

[v-yadongf-msft]

Hi @rgadbois ,

When you have multiple tables, chances are you'll do some analysis using data from all those tables. Relationships between those tables are necessary to accurately calculate results and display the correct information in your reports. Power BI Desktop makes creating those relationships easy. In fact, in most cases you won’t have to do anything, the autodetect feature does it for you. However, sometimes you might have to create relationships yourself, or need to make changes to a relationship. Either way, it’s important to understand relationships in Power BI Desktop and how to create and edit them.

Please refer to:

Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn

Many-to-many relationships in Power BI Desktop - Power BI | Microsoft Learn

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.