Forum Discussion
Error: this could be because there is missing intermediate data to connect the two columns
I have two tables. they both have a column with the same name. And the values in these two columns are the same. When I tried to link these two columns together I got an error: this could be because ...
First thing you should check is if the data types match. If they do, then you need to make sure that one has distinct values that you can key off of. If you give a little more information, data structure etc.. we might be able to help more.
Had the same issue and found that it was because both columns had duplicates. One of the two columns needs to contain only unique data.
Hello,
I have getting same error, checked the data type is same. Infact vlookup in excel works but in power BI i get error saying missing intermediate data.
Please help
Isnt the point of connecting the two columns to create a relationship between the two tables? I'd expect that the only records of value are the duplicates? Confused - please advise
