Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to Solution.
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
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
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |