Forum Discussion

kalleeljas's avatar
kalleeljas
Frequent Visitor
10 years ago
Solved

Problem with merge, "Value was not specified" error

Hello.   Im trying to merge two tables to create a uniqe ID from customernumber and product. The table "ANLÄGGNINGAR" contain the ID i want to use (column "Cistern").   The example below is a su...
Need Help
  • v-micsh-msft's avatar
    v-micsh-msft
    10 years ago

    Hi kalleeljas,

     

    Could you please share us some simple data about the "Sitevision" and "ANLÄGGNINGAR" tables?

    I created some simple table to test and can’t reproduce the error, this should not be related with the join option selected. Please check the table information first, which I suspect the key point should be the "ANLÄGGNINGAR" table.

    In addition, check your Power BI desktop version, make sure it is up-to-date.

    The latest version is available in the following link:

    https://powerbi.microsoft.com/en-us/desktop/

    Regards

     

BhaveshPatel's avatar
BhaveshPatel
Icon for Super User rankSuper User
10 years ago

Hi there,

 

The reason behind this is that The LEFT JOIN returns all rows from the left table (table1), with the matching rows in the right table (table2). The result is NULL in the right side when there is no match and PowerQuery smart sense doesn't even let you create that join if the condition for that is not met.

 

Hope this has clarified your understanding of left join.