Remove all the automatically generated relation

[yhuang1]

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?

[Anonymous]

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]

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.