Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, i have encountered a situation while developing a star schema. my table looks like this
amy | amy@hotmail.com |
jess | amy@hotmail.com |
lee | abc@gmail.com |
lee | xyz@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.
Solved! Go to Solution.
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
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
User | Count |
---|---|
15 | |
5 | |
2 | |
1 | |
1 |
User | Count |
---|---|
19 | |
4 | |
3 | |
1 | |
1 |