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 IVI don't understand how you create the surrogate keys using integer values.
Which functions do you use?
Dataflow is not spark - it is not distributed MPP concept AFAIK
TomMartens
Super User
Super UserHey,
I think this will provide an idea of how to create a surrogate key in Power Query / Dataflows: https://exceleratorbi.com.au/replace-guids-with-a-surrogate-key-for-better-performance/
And there are tons of examples of how to create a surrogate keys in Spark
Regards,
Tom