Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Merge operation expansion not working

I'm trying to connect two tables using merge operation but I get the following error:

We cannot covert type to record type.

 

 

 

Can anyone please help me with this error.

 

 

Here are the steps in my query editor

Source: Joins 2 tables

Expanded above tables

Merge 2: Join another table with above

Expand above table

Merge 3: Join another table with above

Expand above table

Merge 4: Join another table with above

Expand above table

 

 

 

Need Help

2 Replies

  • vanessafvg's avatar
    vanessafvg
    Icon for Community Champion rankCommunity Champion
    5 years ago

    unfortunately you havent given enough information to help understand your problem.

     

    please can you either provide sample data, screen shots with more indepth explanation of what you are trying to join.

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

     

    Looks like there's a problem when converting the data type. This kind of problem is difficult to solve without sample data.

    Please share the pbix to us if you don't have any Confidential Information.

     

    Best Regards,

    Jay