cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
alexhauge Frequent Visitor
Frequent Visitor

Relationships Disappearing from .pbix File

Hello,

 

I am experiencing an issue where Power BI Desktop seems to be losing relationships after they have been created.  I have a .pbix file that is connected to a SQL server via DirectQuery.  This .pbix file was able to connect to the SQL tables without issue and initially functioned with all relationships.  Two new tables and their relationships were added to the .pbix file and then we checked the .pbix file into VSTS.  After checking the file out and making some minor changes (created some new measures and calculated columns) I noticed that many of my relationships were now missing, causing issues with the validity of my data.  At no time were relationships modified using the "Manage Relationships" tool in Power BI Desktop.

 

Has anyone else experienced this?

 

Thanks,

 

Alex

3 REPLIES 3
Moderator v-yuezhe-msft
Moderator

Re: Relationships Disappearing from .pbix File

@alexhauge,

What version of Power BI Desktop do you use? Do you get same issues for those PBIX files that are not checked into VSTS?

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
alexhauge Frequent Visitor
Frequent Visitor

Re: Relationships Disappearing from .pbix File

@v-yuezhe-msft

 

Hi Lydia,

 

I am using Power BI Version: 2.53.4954.621 64-bit (December 2017).  And no.  I have only experienced this with files that have been checked in/checked out of VSTS.

 

Thanks,

 

Alex

Moderator v-yuezhe-msft
Moderator

Re: Relationships Disappearing from .pbix File

@alexhauge,

Could you please upgrade Power BI Desktop to the latest version(2.54.4970.761) and check if the issue still occurs?


Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 6 members 890 guests
Please welcome our newest community members: