Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
mtworski
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
v-sihou-msft
Microsoft Employee
Microsoft Employee

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

View solution in original post

2 REPLIES 2
v-sihou-msft
Microsoft Employee
Microsoft Employee

@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
Frequent Visitor

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.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.