Forum Discussion

PCSConsulting's avatar
PCSConsulting
Regular Visitor
6 years ago
Solved

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

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

  • 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

1 Reply

  • VasTg's avatar
    VasTg
    Memorable Member

    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