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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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