Forum Discussion
Cardinality issue
Hello everyone, I’m encountering a cardinality issue in my Power BI model and would appreciate your help. I’m working with an Excel file that contains a list of applications, with one sheet per mon...
Hello Anonymous
Based on your above explanation, i hope, you should have proper dimensional model.
1) Create a bridge table to handle the duplicate application numbers.
2)Make sure to have unique value on the INS column in the bridge table to eliminate duplicates.
3) Then, relate the bridge table to both the Applications and Source tables.
This will maintain the necessary relationships without overwriting data.Hope this helps
Regards
sanalytics
If it is your solution then please like and accept it as solution
Anonymous One possible solution is to create a bridge table by keeping only unique value (no duplicate). If possible so kindly share the dummy data because it wud be easy to answer your question.