Forum Discussion
Long Keys
I am connecting my tables with a unique key that is pretty long in text and I am dealing with 10 million + rows so the keys are taking up space. Any tips or best practices on how to reduce the size but keep the tables connected?
PowerBI123456
Refer to this post from MattAllington : https://exceleratorbi.com.au/replace-guids-with-a-surrogate-key-for-better-performance/________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂
1 Reply
PowerBI123456
Refer to this post from MattAllington : https://exceleratorbi.com.au/replace-guids-with-a-surrogate-key-for-better-performance/________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂