Data from different table in a R visual.

[mtworski]

Hello,

I need to use data from different tables in an R visual.

These tables have of course a different number of row.

But, PowerBI forces to put all the data in a same dataframe, which is not working if the column length aren't equal.

Do you have any idea to fix this ?

Maybe I can change the autolatic lines powerBI is adding to my script ?

Thanks a lot.

[v-sihou-msft · Accepted solution]

@mtworski

In this scenario, I suggest you create a calculated table to SUMMARIZE() column both tables together. Then drag fields from this calculated table into R visual to execute your R script.

Regards,

[mtworski]

Hello,

I need to use data from different tables in a R visual.

These tables have of course different number of rows.

Unfortunately, PowerBI forces these datas in a same dataframe, which won't work as the column will have different length.

Do you have any idea ?

Maybe I can remove/change these automatic lines added to my script ?

Thank you and sorry for english mistakes if any.