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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

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
Microsoft 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