Is there a way to automatically create relationships between columns from two different tables with the same name (with or without the column names being case sensitive)? I have two tables with multiple columns of same name (some columns are in same letters and some are in the exact same case, all the column though are named in the same way) that I want to create relationship with. As of now, I need to drag each column to the other tables column to create relationship, and there are a lot of columns, which is taking a long time, I am looking for an automated way to sovle this. Here is a snapshot of the tables and few of their columns. Let me know if you need any more information, thanks!
@Anonymous do you know if you are creating more than one relationship between tables, only one relationship will be active, and the others will be inactive? To use an inactive relationship, you have to use the USERELATIONSHIP DAX function in your measure.
Regarding your question, no way to automate this. You have to do it manually, although your use case looks a bit weird.
✨ Follow us on LinkedIn and 
to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@Anonymous do you know if you are creating more than one relationship between tables, only one relationship will be active, and the others will be inactive? To use an inactive relationship, you have to use the USERELATIONSHIP DAX function in your measure.
Regarding your question, no way to automate this. You have to do it manually, although your use case looks a bit weird.
✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Helpful resources
Power BI Monthly Update - September 2025
Check out the September 2025 Power BI update to learn about new features.
Fabric Community Update - August 2025
Find out what's new and trending in the Fabric community.
