Forum Discussion
Model Relationship Organization
I am hoping someone may have a creative solution to managing relationships in their models. I am familar and solid with the nature and behavior of my tables and the relations, but what I am hoping to find is a way to neatly organize my tables in the model tab.
If anyone knows of a snap feature or something that allows for the tables to quickly and uniformly be arranged I would appreciate the advice.
For the image below I know this only took a few minutes to arange, and this is a very simple report. I have additional reports with dozens of tables and dosenz of relationships.
Anonymous unfortunately it is not a very clean design, but one thing I always do I add a separate page for a various relationships so that at one time it is easy to see the relationship between a small set of tables. Although I think the relationship diagram tab needs overhauling and need improvement.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos 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.⚡
4 Replies
Hi Anonymous ,
I don't think currently if there is an automated way to do this. You need to do it manually.
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
Anonymous unfortunately it is not a very clean design, but one thing I always do I add a separate page for a various relationships so that at one time it is easy to see the relationship between a small set of tables. Although I think the relationship diagram tab needs overhauling and need improvement.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos 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.⚡
Hi Anonymous ,
- If you have configure relationships in the data source, Power BI will import them while getting data.
- You could use the option of Autodetect. (On the Home tab, select Manage Relationships > Autodetect.) Power BI Desktop looks at column names in the tables you're querying to determine if there are any potential relationships. If there are, those relationships are created automatically. If Power BI Desktop can't determine with a high level of confidence there's a match, it doesn't create the relationship. However, you can still use the Manage relationships dialog box to manually create or edit relationships.
For more details, please take a look at the document.
Create and manage relationships in Power BI Desktop
Excepting the option, there isn't other workaround to manage them automatically. We still do it manually.
Hi Xue,
Thank you for getting back to my question. I'm familar with the nature of the relationships and model building. I am hoping to find a way to neatly organize it on the model tab so when there are dozens of relationsips and tables I can clearly congergate with a clean look. I was hoping to have something similar to the snapping function that is available when working with visuals.
