Forum Discussion
Create single-column dimension or leave in fact table?
Super UserHello TallArnie ,
I would made a dimension table with one column of values and a column for key and used the key in the fact table.
since when you refresh, instead of refreshing several characters per row which are the words, its better to refresh 1 or 2 character per row as a key.
check the normalization part in this article https://learn.microsoft.com/en-us/power-bi/guidance/star-schema
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Thank you Idrissshatila
All my data is currently in a flat CSV file, with the operational status being one of the columns. And re-reading/refreshing that data will only need to be done on an occasional basis.
Leaving it as-is means I don't need to do anything to this column in Power Query, whilst moving it into a dimension table means I would need to split it off and generate a key. I am not sure if refreshing the latter would be faster than the former.