Data refresh visualization error because new relationships has been auto-detected

[PCSConsulting]

A couple of visualizations from different PBIX datasets failed to be refresh it because new relationships has been autodetected. Those datasets has been refreshed automatically each 2 hours without a problem for more than 2 months. Would like to know if somebody has been experiencing this issue before and how do you fix it?

Thanks for all in advance, Mireya

[VasTg · Accepted solution]

@PCSConsulting 

Do you have the options enabled? If so, disable them to avoid the error.

But find out what caused it to create a new relationship. Its always a good practise to choose the required columns(in query editor) so that whenever a new column is added to the source, it won't get pulled into Power BI model automatically.

If it helps, mark it as a solution

Kudos are nice too