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

Power BI desktop hangs on relationships when trying to create a new relationship between 2 tables.

I'm trying to create a relationship between 2 tables in Power BI using Direct Query. When I go to the relationships pane and connect 2 rec id columns it seems as though Power BI gets stuck in the relationship window. I have to end task to kill the application before I can get back to the normal design view in Desktop. I've been having this issue for the last 3 versions of Power BI Desktop x64 at least. I was hoping it was just a bug that would eventually get fixed but I suspect there's something more going on. 

One of my tables does not load any data on the preview of the table when building the relationship and I suspect there's something related here, but I don't know that for sure. I did a query in sql to see if there were duplicates on the fields I'm trying to use as my join fields. 

All my research online seems to refer to 2017 and earlier which I don't believe is relevant at this time as the product has changed significantly, but I've looked at it nonetheless. Thank you in advance for any suggestions you can give.

1 ACCEPTED SOLUTION

Accepted Solutions
SeanTodd Frequent Visitor
Frequent Visitor

Re: Power BI desktop hangs on relationships when trying to create a new relationship between 2 table

August update resolved this issue. 


@SeanTodd wrote:

I'm trying to create a relationship between 2 tables in Power BI using Direct Query. When I go to the relationships pane and connect 2 rec id columns it seems as though Power BI gets stuck in the relationship window. I have to end task to kill the application before I can get back to the normal design view in Desktop. I've been having this issue for the last 3 versions of Power BI Desktop x64 at least. I was hoping it was just a bug that would eventually get fixed but I suspect there's something more going on. 

One of my tables does not load any data on the preview of the table when building the relationship and I suspect there's something related here, but I don't know that for sure. I did a query in sql to see if there were duplicates on the fields I'm trying to use as my join fields. 

All my research online seems to refer to 2017 and earlier which I don't believe is relevant at this time as the product has changed significantly, but I've looked at it nonetheless. Thank you in advance for any suggestions you can give.


 

4 REPLIES 4
Community Support Team
Community Support Team

Re: Power BI desktop hangs on relationships when trying to create a new relationship between 2 table

Hi @SeanTodd ,

 

What data source did you use? Based on my test using sql database. I cannot reproduce your issue here.

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

Re: Power BI desktop hangs on relationships when trying to create a new relationship between 2 table

@v-frfei-msft Standard SQL direct query. Nothing special. 

Community Support Team
Community Support Team

Re: Power BI desktop hangs on relationships when trying to create a new relationship between 2 table

Hi @SeanTodd ,

 

I recommend you to create a support ticket for help if you are a pro user.
 
https://powerbi.microsoft.com/en-us/support/
 

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

Re: Power BI desktop hangs on relationships when trying to create a new relationship between 2 table

August update resolved this issue. 


@SeanTodd wrote:

I'm trying to create a relationship between 2 tables in Power BI using Direct Query. When I go to the relationships pane and connect 2 rec id columns it seems as though Power BI gets stuck in the relationship window. I have to end task to kill the application before I can get back to the normal design view in Desktop. I've been having this issue for the last 3 versions of Power BI Desktop x64 at least. I was hoping it was just a bug that would eventually get fixed but I suspect there's something more going on. 

One of my tables does not load any data on the preview of the table when building the relationship and I suspect there's something related here, but I don't know that for sure. I did a query in sql to see if there were duplicates on the fields I'm trying to use as my join fields. 

All my research online seems to refer to 2017 and earlier which I don't believe is relevant at this time as the product has changed significantly, but I've looked at it nonetheless. Thank you in advance for any suggestions you can give.


 

Helpful resources

Announcements
Community Highlights

Community Highlights

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

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 405 members 4,321 guests
Please welcome our newest community members: