Forum Discussion
help: new auto relationship
Hi Hummingbird,
this is correkt. i want to re-enable the automatic relationship in Power BI.
I tried step 1 to 5 but this button is grayed out. Also i reset the the chache in "Data load" and restart Power BI, but it don´t work. I load four new tables from the DB in the Power BI view. So i hope, i can use the automatic for the four, but also there, the button is grayed out.
hummingbirdHelper II
Hi,
If the option to create a relationship is still grayed out, even after resetting the cache and restarting Power BI Desktop, you may need to take a few additional steps to resolve the issue:
Check if the tables have unique column names: The automatic relationship feature only works if the tables have unique column names. If the column names are not unique, you will need to change them or create a calculated column to differentiate them.
Make sure the tables have the same data type: The columns in the tables that you want to relate to each other must have the same data type. For example, if you have a column named "Date" in one table, and another column with the same name in another table, both columns must be of the data type "Date".
Check for hidden columns: Hidden columns can also prevent the automatic relationship feature from working. To check for hidden columns, go to the Fields tab, right-click on a column, and select "Unhide All Columns".
Try importing the data again: If all the above steps fail, you can try importing the data into Power BI Desktop again. This will create a new data model and should allow you to establish automatic relationships between the tables.