Operations on multiple tables / datasets using Edit Queries and R in Power BI

Question

I have two tables (tbl_A and tbl_B) in a Power BI file that I would like to convert and analyze using the Run R Script function in Edit Queries .

This will include handling missing values ​​and joining tables. However, when starting R, it seems that I can only perform operations on one table at a time. This is because the Run R Script function only imports data from a table that is active when you click the Run R Script button. This data is then stored in the dataset variable .

, , R Power BI . , , R. , , , , . , R Power BI?

Answer 1

:

R script [dataset = "Renamed Columns", dataset2 = tbl_A] . ( ), R script, tbl_A , . .

---

, , - PowerBI:

. /. . , ...

/ . . Public:

---

:

, , PowerBI - . Excel, , tbl_A tbl_B, . :

tbl_A

Date        Price1  Price2
05.05.2016  23,615  24,775
04.05.2016  23,58   24,75
03.05.2016  0       24,35
02.05.2016  22,91   24,11
29.04.2016  22,93   24,24

tbl_A

tbl_B

Date        Price3  Price4
02.06.2016  19,35   22,8
01.06.2016  19      22,35
31.05.2016  19,35   22,71
30.05.2016  15,5    21,85
27.05.2016  19,43   22,52

tbl_B

---

PowerBI tbl_A :

tbl_B, :

"" , . , :

, , PowerBI . :

, PowerBI , , Date. . , :

, , , tbl_B , . , Type1:

, R script. script rbind(). , . , B Price3 Price4 Price1 Price2, :

:

, ( ), R script. , , .

R Script. , dataset script. tbl_B , tbl_B R Script:

script , OK :

. -, , . -, , tbl_B , . , , . , , dataset2=tbl_A, :

Enter.

" " , , R script:

, R :

df_B <- dataset
df_A <- dataset2
df_temp <- rbind(df_A, df_B)

output <- df_temp

OK, , :

, , .

!

, . R script , :

tbl_B tbl_A. , , R script, R .