Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
GeorgeFP
Frequent Visitor

Is it better to create a custom key for lookup (dim) table, if an existing column exist (as string)

Hi there,
This is a question about data modelling.

 

I am no expert, but I understand the idea of foreign and primary keys for relationships.

 

Question - is it necessary or beneficial to create a column with an integer value in the lookup (dim) table as the key even if another column in text (e.g. country) is available to use as a key?

 

Thanks in advance.
Regards George

1 ACCEPTED SOLUTION
selimovd
Super User
Super User

Hey @GeorgeFP ,

 

yes, integer is always the best option for the keys.

Like this the performance and also the amount of space in the data model have the best impact.

 

https://www.sqlbi.com/articles/the-importance-of-star-schemas-in-power-bi/

https://www.sqlbi.com/blog/marco/2017/10/02/why-data-modeling-is-important-in-powerbi/

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic

View solution in original post

2 REPLIES 2
GeorgeFP
Frequent Visitor

Thank you Denis

selimovd
Super User
Super User

Hey @GeorgeFP ,

 

yes, integer is always the best option for the keys.

Like this the performance and also the amount of space in the data model have the best impact.

 

https://www.sqlbi.com/articles/the-importance-of-star-schemas-in-power-bi/

https://www.sqlbi.com/blog/marco/2017/10/02/why-data-modeling-is-important-in-powerbi/

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Find out what's new and trending in the Fabric Community.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.