Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
The ids in accounts table are unique. They corralate with the contacts table. One Id from accounts table can have the same Id 3 times in the contact table. It wants me to do a many to many relationship only and I dont understand why.
Solved! Go to Solution.
Hi @ChannelDevMike ,
multiple null values in accounts would indeed force you to use a many to many relationshipt between tabels.
You need to ask yourself whether:
If you don't need the null accounts, you can delete them during data transformation.
If you do need them, your best option seems to create a new & unique account ID, then add that ID to your contacts table so that you can have a one - to - many relation between the 2 tables.
Unless multiple empty values from the accounts table through it off.. If so, how would I correct this?
Hi @ChannelDevMike ,
multiple null values in accounts would indeed force you to use a many to many relationshipt between tabels.
You need to ask yourself whether:
If you don't need the null accounts, you can delete them during data transformation.
If you do need them, your best option seems to create a new & unique account ID, then add that ID to your contacts table so that you can have a one - to - many relation between the 2 tables.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
21 | |
2 | |
2 | |
2 | |
2 |