Link two columns from different tables in Data Sources

[Anonymous]

Hi,

This sounds simple and I have looked around but I can't find an aswer - maybe becuase I am still starting.

I wanted to get the values from ColumnA into Column1 automatically. ColumnA and Column1 are in different tables.

So I basically wanted to mirror ColumnA from TableA to Column1 from Table1. 

I want to do this because TableA cannot be edited (DB connection) and I wanted to fiddle with the values and this way I could get the data on a different table and change it.

Thanks!

Ricardo

[v-gizhi-msft · Accepted solution]

Hi,

Please try to use Append Queries:

Reference:

https://www.poweredsolutions.co/2019/04/09/combine-or-append-data-in-power-bi-power-query-main-conce... 

Hope this helps.

Best Regards,

Giotto Zhi

[Anonymous]