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.
Why i cant use Compound Key in the binding of the tables?
Case:
Company 1 Seller 5
Company 1 Seller 6
Company 2 Seller 5
Should o use one column like "First Pk"_"Second Pk"?
1_5
1_6
2_5
Thanks... waiting for a reply.
Solved! Go to Solution.
Hi @brunozanoelo ,
Compound keys are less essential in an Analytics/Reporting environment, but yes if you concatenate the values you can create relationships between tables.
Hi @brunozanoelo ,
Compound keys are less essential in an Analytics/Reporting environment, but yes if you concatenate the values you can create relationships between tables.
Please be careful concatenating values to create compound keys, ideally convert id's to text and use a separator between them. This is a potential performance hit (text lookups are much slower than integer), but it is often necessary to avoid duplicate keys.
Consider:
Company 1 employee 12 key=112
Company 11 employee 2 key=112
Hey @Phil_Seamark,
I think you need to do some clarification here. On what regards do you claim that compound keys are less essential? Why duplicate data which degrade performance??
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |