Reply
arashaga
Helper I
Helper I

Error connecting Through R

I am getting the following error when I paste the following code in the R script connector box. It is simple script that runs on RStudio.

 

 

df1 <- data_frame(school = c("A", "B", "C", "D", "E", "F", "G", "H"),
perc_25 = c(950, 1140, 1140, 820, 920, 950, 850, 850),
perc_75 = c(1190, 1410, 1380, 1030, 1130, 1150, 1060, 1050),
diff = as.numeric(perc_75 - perc_25))

 

Details: "ADO.NET: R script error.
Error: could not find function "data_frame"
Execution halted

 

Does nayone have any ideas why this not running. I have done some visual in powerBI using R previously but I am not sure what has changed. Thanks
"

1 ACCEPTED SOLUTION
v-jiascu-msft
Microsoft Employee
Microsoft Employee

Hi @arashaga,

 

Which library does data_frame belong? It could be data dot frame which is data.frame(). As far as I know, I can't call other columns when initiating the data frame. Please try it like below or include the proper library.

 

# include the proper library which has the data_frame.
library(lib)
your other codes go here.
school <- c("A", "B", "C", "D", "E", "F", "G", "H")
perc_25 <- c(950, 1140, 1140, 820, 920, 950, 850, 850)
perc_75 <- c(1190, 1410, 1380, 1030, 1130, 1150, 1060, 1050)
diff <- perc_75 - perc_25
df1 <- data.frame(school = school, perc_25 = perc_25, perc_75 = perc_75, diff = diff)

r.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-jiascu-msft
Microsoft Employee
Microsoft Employee

Hi @arashaga,

 

Could you please mark the proper answers as solutions?

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Yes. Thank you for the solution!

v-jiascu-msft
Microsoft Employee
Microsoft Employee

Hi @arashaga,

 

Which library does data_frame belong? It could be data dot frame which is data.frame(). As far as I know, I can't call other columns when initiating the data frame. Please try it like below or include the proper library.

 

# include the proper library which has the data_frame.
library(lib)
your other codes go here.
school <- c("A", "B", "C", "D", "E", "F", "G", "H")
perc_25 <- c(950, 1140, 1140, 820, 920, 950, 850, 850)
perc_75 <- c(1190, 1410, 1380, 1030, 1130, 1150, 1060, 1050)
diff <- perc_75 - perc_25
df1 <- data.frame(school = school, perc_25 = perc_25, perc_75 = perc_75, diff = diff)

r.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)