Forum Discussion

rschaudhr's avatar
rschaudhr
Icon for Resolver II rankResolver 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

Anonymous's avatar
Anonymous
Not applicable
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