Forum Discussion
sgeheeb
Resolver I
Resolver IModel Design - Using a Surrogate Key
Hi, I am trying to figure out which way of designen my data model is better. Background: I am building a data model based on Business Central (SaaS) data, so I cannot perform any SQL operati...
You should be fine using the concatenated values as strings, they will be compressed and stored the same way as integers. There's a really good article with benchmark tests at https://www.maxwikstrom.se/performance/power-bi-data-types-in-relationships-does-it-matter/
johnt75
Super User
Super UserYou should be fine using the concatenated values as strings, they will be compressed and stored the same way as integers. There's a really good article with benchmark tests at https://www.maxwikstrom.se/performance/power-bi-data-types-in-relationships-does-it-matter/
sgeheebThanks! That's a great artilcle indeed! I think I'll go with the concatenated string, it will also make the transformation process easier to understand