cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
mtworski Frequent Visitor
Frequent Visitor

Data from different table in a R visual.

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-sihou-msft
Moderator

Re: Data from different table in a R visual.

@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,

2 REPLIES 2
mtworski Frequent Visitor
Frequent Visitor

Using R visual with data from different tables.

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.

Moderator v-sihou-msft
Moderator

Re: Data from different table in a R visual.

@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,

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 145 members 2,382 guests
Please welcome our newest community members: