cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
HumzaIftikhar
Frequent Visitor

Star Schema

Hi, i have encountered a situation while developing a star schema. my table looks like this

 

amyamy@hotmail.com
jessamy@hotmail.com
leeabc@gmail.com
leexyz@gmail.com

i am trying to develop my dimensional table but facing this duplication. is there any idea to fix this situation to avoid duplication while populating and fethcing the results. 

your help will highly regarded. 

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

Hi @HumzaIftikhar,

Did you mean your table includes some duplicate records with the same keys? If that is the case, you can extract these duplicate keys to create a new table with unique values as a bridge to link the raw table and the fact table with these keys.

How to Join Many to Many with a Bridge Table in Power BI | Seer Interactive

If the above does not help, can you please share some more detailed information to help us clarify your scenario?

How to Get Your Question Answered Quickly 

Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

1 REPLY 1
v-shex-msft
Community Support
Community Support

Hi @HumzaIftikhar,

Did you mean your table includes some duplicate records with the same keys? If that is the case, you can extract these duplicate keys to create a new table with unique values as a bridge to link the raw table and the fact table with these keys.

How to Join Many to Many with a Bridge Table in Power BI | Seer Interactive

If the above does not help, can you please share some more detailed information to help us clarify your scenario?

How to Get Your Question Answered Quickly 

Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors