Data Modeling
When Keys Matter: Why Integer Relationships Outperform Text in Complex Power BI Models
Testing showed that models using text-based relationship keys performed up to 5x slower than those using integer surrogate keys as complexity increased.
Read article