cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jtsmithers
New Member

Disabling auto-detect relationships on refresh

Hi there,

 

I have a PowerBI desktop file which I manually refresh fairly often. Each time I do this, PowerBI automatically detects and creates relationships which I do not want to be created. Is there any way to avoid this?

1 ACCEPTED SOLUTION
HarrisMalik
Continued Contributor
Continued Contributor

@jtsmithers This can be done by going to options:

 

File -> Options & Settings -> Options -> Data load

 

Under Relationships you can switch on or off different options.

View solution in original post

2 REPLIES 2
HarrisMalik
Continued Contributor
Continued Contributor

@jtsmithers This can be done by going to options:

 

File -> Options & Settings -> Options -> Data load

 

Under Relationships you can switch on or off different options.

Awesome, thanks @HarrisMalik!

Helpful resources

Announcements
March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

March Events 2023A

March 2023 Events

Find out more about the online and in person events happening in March!

Top Solution Authors