Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

0

Automatic Relationships are creating "Both" relationships

In the November release, Power BI Desktop is creating "Both" (bi-directional) relationships when a single fact table is detected in the data model.  The default should always be "Single" due to performance issues (and has been for several months).  Most modelers do not fully recognize the impacts that bi-directional relationships can have on a Data Model.

Status: Delivered
Comments
v-haibl-msft
Employee

@BraneyBI

 

In Power BI Desktop, Both is the default direction. If you’d like Singe to be the default one, you can create an idea in http://ideas.powerbi.com to get votes. Maybe we can have an option to change the default direction in the future.

 

Best Regards,

Herbert

Vicky_Song
Impactful Individual
Status changed to: Delivered