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

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I ended up here on a DuckDuckGo search for th same error. I was getting the same error and was able to get around it with the merge as new, but that wasn't a solution.

 

I had a look at mine again and noticed that I was creating a circular reference even though I wasn't getting the circular reference error. I had the main query and referenced this main query to do some cleaning and then tried to merge this new query back into the main query! (Stupid I know). I stripped the main into 2 queries (raw data + cleaning queries) and the third query to do other matching etc. Query 2 and 3 referened Query 1 and works fine. 

 

Query 2 reference Query 1 > Query 1 merge Query 2 = "Value was not specified"

Query 2 and 3 reference Query 1 (raw data) > Query 2 merge Query 3 = OK