Forum Discussion

rgadbois's avatar
rgadbois
Frequent Visitor
3 years ago

Schema Issues

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...
Need Help
v-yadongf-msft's avatar
v-yadongf-msft
Community Support
3 years ago

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.