Using two different tables for an R script

[Anonymous]

I have an R script that uses data from 2 different tables. The tables have different columns name (only one in common). My question is: Is there a way on Power Bi to integrate this using Power Query with an R script, even if the tables are very different? The reason why this needs to be integrated in Power Bi is because of data security and easy use for the user of the algorithm, so any solution would help! 

[v-easonf-msft · Accepted solution]

Hi, @Anonymous 

Please refer to this same thread about How to use Python with multiple tables in the Power Query Editor  .
Here they discuss how to create a new table using a Python script that uses two existing tables as input by performing a  left join using pandas merge

You can also check whether the solution of the following process is  applicable to you.

operations-on-multiple-tables-datasets-with-edit-queries-and-r-in-power-bi 

Best Regards,
Community Support Team _ Eason