Forum Discussion
Anonymous
3 years agoNot applicable
help: new auto relationship
Hi. I have deleted / removed the automatic relationship in Power BI. Now I do not get the tables automatically assigned. I have close to 100 tables and the autoamtic assignment was great. I was only ...
hummingbird
Helper II
3 years agoHi,
It sounds like you are trying to recreate the automatic relationships in Power BI after deleting them. To re-enable the automatic relationships, you can try the following steps:
- Close and reopen Power BI Desktop.
- Go to the Fields tab and make sure that the tables have been loaded and are in the field list.
- Right-click on one of the columns in the table and select "Create relationships".
- In the Create Relationship dialog box, select "Automatic" as the relationship type. Power BI should automatically detect and create the relationships between the tables based on the columns with the same names.
- Repeat this process for each table that you need to establish a relationship with.
If the option to create a relationship is still grayed out, you can try resetting the Power BI Desktop data model. To do this, go to the Home tab, select "Options and Settings" and then "Options." In the Options dialog box, go to the "Data Load" section and select "Reset." This will reset the data model and clear any existing relationships. After this, you should be able to create new relationships.