cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Highlighted
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

Highlighted
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
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (2,952)