cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Myles_POLB Occasional Visitor
Occasional Visitor

PBID switches to report tab after creating relationship

I have several tables inluded in my Query from SQL 2017. The tables have foreign key constraints to a central table (Not a fact table). The relationships are not auto detected. I'm creating them by dragging and dropping from the primary key to the foreign key in the relationship. The parent will have all primary keys and the child has a subsection of the foreign keys.

 

Every time I create a relationship using the relationship tab the report tab pops on top after I create the relationship. I think this is an unecessary step to switch back and forth between the two tabs just to create the relationships.

 

Is this a bug?

01-CreateRelationshipInTheRelationshipTab.png1. Drag the PK to the FK02-CreateRelationshipDialog.png2. The Create relationship window opens03-PowerBISwitchesTabsToTheReportTab.png3. Power BI Desktop switches to the Report tab04-ManualSave.png4. I do manual save06-RelationshipAppearsAFewSecondsAfterSave.png5. Switch back to Relationships View07-BackToFirstWindow.png6. Relationship shows up after a few seconds.

If I save after I switch back the relationship does not show up until the save. 

 

Either way the Relationship tab switches to the Report tab. 

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft v-huizhn-msft
Microsoft

Re: PBID switches to report tab after creating relationship

Hi @Myles_POLB,

This is a dupe of VSTS 11370713: “Bug Bash: After editing a relationship and closing the relationship dialog box, Desktop jumps to the report view instead of staying on the diagram view.” Issue affected only editable DirectQuery models. Project Team have checked the fix for this issue on the Dec 22nd  , so it’s going to be available in February 2018. thanks for understanding.

Best Regards,
Angelia

View solution in original post

2 REPLIES 2
Microsoft v-huizhn-msft
Microsoft

Re: PBID switches to report tab after creating relationship

Hi @Myles_POLB,

Based on your screenshot, you live connect to your database. I can reproduce your scenario using the latest version(2.53.4954.621). While Power BI Desktop won’t switche to the Report tab automatically when I get data using import model. I also test using Power Bi October version, it still won't switch back and forth. I have consulted the Product team if it's a expected behaviour or a issue. I will post update if I get any response.

Thanks,
Angelia

Microsoft v-huizhn-msft
Microsoft

Re: PBID switches to report tab after creating relationship

Hi @Myles_POLB,

This is a dupe of VSTS 11370713: “Bug Bash: After editing a relationship and closing the relationship dialog box, Desktop jumps to the report view instead of staying on the diagram view.” Issue affected only editable DirectQuery models. Project Team have checked the fix for this issue on the Dec 22nd  , so it’s going to be available in February 2018. thanks for understanding.

Best Regards,
Angelia

View solution in original post

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors