Can’t create a relationship? Time for a surrogate key in Power BI!

This looks at a scenario of a hierarchy but the child ID repeats and we can’t create a relationship on it. Adam looks at how you could use a surrogate key to get a relationship in place so you can build your Power BI report. 📢 Become a member: ******************* Want to take your Power BI skills to the next level? We have training courses available to help you with your journey. 🎓 Guy in a Cube courses: ******************* LET’S CONNECT! ******************* -- -- -- -- -- -- ***Gear*** 🛠 Check out my Tools page - #PowerBI #PowerQuery #GuyInACube