Forum Discussion
powerbiexpert22
Impactful Individual
Impactful Individualalphanumeric columns
is it okay to use below values (sample) for joining columns between two tables in power bi , these values are used to denote primary key of column, likewise we have such alphanumeric column values as...
powerbiexpert22Impactful Individual
Impactful IndividualHi mickey64
will there be any performance related concerns for using these text columns for joining, as per my understanding we should use numeric columns for better performance
rajendraongole1
Super User
Super UserHi powerbiexpert22 Adding to the performance , yes it is true when comparisons and joins on alphanumeric columns can be slower because string comparisons are generally more complex than numeric comparisons.Usually result in faster comparisons and joins due to simpler comparison operations as power bi use the columnar storage.
Hope it helps
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!