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

[Anonymous]

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.

[Anonymous · Accepted solution]

August update resolved this issue. 

---

@Anonymous 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.

---

[v-frfei-msft]

Hi @Anonymous ,

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

[Anonymous]

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

[v-frfei-msft]

Hi @Anonymous ,

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