Forum Discussion

yhuang1's avatar
yhuang1
Frequent Visitor
3 years ago

Remove all the automatically generated relation

Hi there,

 

I have many data loaded, and the desktop automatically generate the relationship between them. I guess it is too late to change the setting so that when you load new data it will not auto generate the relationship since they are already in the model. I can click the link and 'delete' it one by one, which is time consuming. I searched and found an MS article mentioned that one should be able to press control key and click the link to select multiple links, then delete them altogether, but I tried and it didn't work. Any idea?

 

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi yhuang1 

    You can manage how Power BI treats and automatically adjusts relationships in your reports and models. To specify how Power BI handles relationships options, select File > Options and settings > Options from Power BI Desktop, and then select Data Load in the left pane. The options for Relationships appear.

     

     

    • yhuang1's avatar
      yhuang1
      Frequent Visitor
      3 years ago

      Thanks, but as I mentioned, data has been loaded already, changing the setting is too late. It only applys to newly loaded data. I tried to uncheck the "Autodetect new relationships after data is loaded", and all the links already built are still there.