Forum Discussion
Solved
Table contains Null values
Hi All I am trying to create a relationship between to imported Excel tables. The error message states that the relationship cannot be made because the id column contains null values . Now th...
There are a few things you can try.
1: Check in the Data view table in Power BI and scroll to the bottom of the data and see if there is anything at the bottom of the data. Sometimes there can be null values here.
2: Is the data your pulling from excel in a table? I.e. have you converted the data into an actual table by inserting one? This can sometimes fix the issue.
3: If you can convert the excel data into CSV's this can fix the issue.
Lastly, what are the values in the ID column? Are they numbers/letters/mix of both?
Hope this helps.
Giles
Please check both column ..refernece and referecing , Would like to paste here excel screensot or send me dummy excel data i will try