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

     

v-micsh-msft's avatar
v-micsh-msft
Icon for Microsoft Employee rankMicrosoft Employee
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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    I worked around this error by "Merging Queries as New" instead of just a merge. It's not really a solution but it allowed me to get around the join problem!