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.
Go to Solution.
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.
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.
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!
Check out what's new in the Power BI Community!