Forum Discussion

paddy_gfb's avatar
paddy_gfb
Frequent Visitor
5 years ago

Table relationship issue

Hi, I am trying to create a simple relationship between an existing tabe and a new table in power bi desktop.  The issue i am having is that the existing table appears to be blank when the relation...
amitchandak's avatar
amitchandak
Super User
5 years ago

paddy_gfb , check how much memory power bi is taking and the system has some free memory.

 

You can try drag and drop. Drag the JobNo from one table and drop it on JobNo of another table.

 

paddy_gfb's avatar
paddy_gfb
Frequent Visitor
5 years ago

I have tried deleting all un-necessary tables, restarting the computer and i can confirm that i have enough computer memory. 

 

The existing connections to the table in question are working well, but it just wont let me add any new conenctions. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi paddy_gfb ,

    First, please make sure the field table JimJobComm[JobNo] on one side of the relationship with unique values. Besides this, could you please help check and answer the following questions in order to make troubleshooting?

    • Is there any blank row or duplicated rows in table JimJob - Kit?
    • Whether the data type of the fields in table JimJob - Kit match the actual data type of data?
    • Whether the table JimJob - Kit can display successfully in Power Query Editor?
    • Does the table JimJob-Kit have a lot of data?
    • Which table also be created relationship with the table JimJob - Kit except the table JimJobComm?

    In addition, please try to update the version of your Power BI Desktop to the latest one if it still not be the latest version.

    Best Regards

    Rena