Automatic deletion of table relationships.

[eraldo_DP]

When I make a change in Power Query, for example, removing a step in the advanced editor without changing the format or deleting a column used in a relationship, when the change is saved, some relationships between tables are automatically deleted. This did not happen in previous versions.

In the example, the relationship is established with a column in text format that has not undergone any changes and yet was removed.

[v-stephen-msft]

Hi @eraldo_DP ,

Please try to turn off the 2nd option "Update or delete relationships when refreshing data"

Reference: Power BI Design Tip: Disable the Auto-Detect Relationship - RADACAD

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

If it won't work, please provide me with more details about the issue.      

Best Regards,

Stephen Tao

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

[eraldo_DP]