Database Relationship - Refresh

Hi pgree 

Please correct me if I wrongly understood your question .

There are three settings related to relationship in the system settings .

• Import relationships from data sources on first load .
• Update or delete relationships when refreshing data
• Autodetect new relationships after data is loaded .

If the data you import from the database already has a relationship, you mainly check the first parameter, and then import the data, you can see the relationship between the tables .

If you import the data first and do not check the first parameter, then the relationship between the tables will not be synchronized to the power bi. At this time, you can automatically create the relationship through the Autodetect in the Manage relationships .

Therefore, before importing relational data, you should confirm whether the first parameter is enabled. In this way, the relationship from the database can be synchronized.

More info about relationships can refer to the link

Create and manage relationships in Power BI Desktop - Power BI | Microsoft Docs

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.