Reply
jwang19
Frequent Visitor
Partially syndicated - Outbound

Star Schema Relationships

Hi,

 

Could someone explain why this is a one to many relationship from fact tables to dimension tables in the star schema?

Thanks in advance!

 

jwang19_0-1680855697759.png

 

Understand star schema and the importance for Power BI - Power BI | Microsoft Learn

jwang19_1-1680855745076.png

 

1 ACCEPTED SOLUTION

Syndicated - Outbound

Many to One should be correct answer.

Thanks
Pijush




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





View solution in original post

3 REPLIES 3
PijushRoy
Super User
Super User

Syndicated - Outbound

Hi @jwang19 

What is the source of the first image?

Thanks
Pijush




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





Syndicated - Outbound

It's the practice assessment from Microsoft.

Syndicated - Outbound

Many to One should be correct answer.

Thanks
Pijush




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)