Forum Discussion
YevgenyM
Advocate IV
Advocate IVPower BI Composite Keys: Performance vs. Maintenance tradeoffs in a Lakehouse architecture
Hi All, Since Power BI doesn't natively support relationships using multiple columns, creating a single-column surrogate/composite key is a standard requirement. However, when working within a Lake...
YevgenyMAdvocate IV
Advocate IVHi All,
Since Power BI does not natively support relationships using multiple columns,
How do you create single field generenrated keys ? Specifically if you work with Lakehouse?
Which solution do you use?
How do you maintain it in the code?
TomMartens
Super User
Super UserHey YevgenyM,
see my anserwer here: https://community.fabric.microsoft.com/t5/Desktop/Power-BI-Composite-Keys-Performance-vs-Maintenance-tradeoffs-in/m-p/5287880#M1471868
Regards,
Tom