Forum Discussion

rschaudhr's avatar
rschaudhr
Resolver II
1 year ago
Solved

Moving column from one table to another table.

I have two tables. One table (lets say table1) in direct query from dataflow. The other table (lets say table 2) is an import query from sql server. I want to be able to add column in table1 columns ...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi all,thanks for the quick reply, I'll add more.

    Hi rschaudhr ,

    Regarding your question, you are using a composite model and the “Relate” function is not supported.

    The “Relate” function is only supported in the following cases:

    1.Relationships between Import Mode tables
    2.Relationship between Direct Query Mode tables from the same SQL database

     

     

    1.You can create form table visual with similar fields to achieve a similar effect

     

    2.You can switch Table 1 to import storage mode,then you can use the “Relate” function.Or you can use merge operations with Power Query

     

    Best Regards

vanessafvg's avatar
vanessafvg
Community Champion
1 year ago

what type of relationship do you have set up between the tables?

rschaudhr's avatar
rschaudhr
Resolver II
1 year ago

It is one to many relationship. The table2 has unique values whereas table1 has many values. It is joined on one field called key. I hope I have answered your question. Thanks!