Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
nicoperrot
Regular Visitor

Using two different tables for an R script

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! 

1 ACCEPTED SOLUTION
v-easonf-msft
Community Support
Community Support

Hi, @nicoperrot 

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

View solution in original post

1 REPLY 1
v-easonf-msft
Community Support
Community Support

Hi, @nicoperrot 

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.