Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

Automatic relationship detection between tables

I am using power BI in microsoft fabric on the web. I have got all the tables in semantic model and I am able to define relationships between tables tables manually using model layout. 

however, I want the relationships between tables to be detected automatically. I don't see an option for this either in model layout or anywhere in power BI service in Microsoft fabric? Is there a way to detect relationships between tables automatically? This question is not about power BI desktop but is about using power BI within microsoft fabric. Please advice.

1 ACCEPTED SOLUTION
olgad
Super User
Super User

Unfortunately in the Power BI service within Microsoft Fabric, this feature isn't available. Therefore, you'll need to manually define relationships between your tables using the model layout interface.


DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO/LIKE!
PROUD TO BE A SUPER USER!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime

View solution in original post

4 REPLIES 4
v-pagayam-msft
Community Support
Community Support

Hi @svivek  ,

Hope that your query has been resolved. If our community member's response addressed your question,

If it helps, please give us Kudos and consider Accept it as a solution and click YES to help the other members find it more quickly.

Thank you for being a part of the Microsoft Fabric Community Forum!

v-pagayam-msft
Community Support
Community Support

Hi @Anonymous ,
As @olgad mentioned ,I just wanted to kindly follow up to see if you had a chance to review the previous response. Please let me know if it was helpful or needed further assistance. If yes, please Accept the answer and give Kudos that it will be helpful to others to find it quickly.
Thank you for being a part of Microsoft fabric Community Forum!

v-pagayam-msft
Community Support
Community Support

Hi @Anonymous  ,

Hope that your query has been resolved. If olgad response addressed your question,

If it helps, please give us Kudos and consider Accept it as a solution and click YES to help the other members find it more quickly.

Thank you for being a part of the Microsoft Fabric Community Forum!

olgad
Super User
Super User

Unfortunately in the Power BI service within Microsoft Fabric, this feature isn't available. Therefore, you'll need to manually define relationships between your tables using the model layout interface.


DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO/LIKE!
PROUD TO BE A SUPER USER!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.