Forum Discussion
R error
The following error appears when running R script in powerbi but not in RStudio, please help.
My R version is 3.3.1
DataSource.Error: ADO.NET: R script error.
Attaching package: 'dplyr'
The following objects are masked from 'package:stats':
filter, lag
The following objects are masked from 'package:base':
intersect, setdiff, setequal, union
Error in check_input(x) :
Input must be a character vector of any length or a list of character
vectors, each of which has a length of 1.
Calls: %>% ... unnest_tokens -> unnest_tokens_ -> tokenfunc -> tf -> check_input
Execution halted
Details:
DataSourceKind=R
DataSourcePath=R
Message=R script error.
Attaching package: 'dplyr'
The following objects are masked from 'package:stats':
filter, lag
The following objects are masked from 'package:base':
intersect, setdiff, setequal, union
Error in check_input(x) :
Input must be a character vector of any length or a list of character
vectors, each of which has a length of 1.
Calls: %>% ... unnest_tokens -> unnest_tokens_ -> tokenfunc -> tf -> check_input
Execution halted
ErrorCode=-2147467259
ExceptionType=Microsoft.PowerBI.Radio.RScriptRuntimeException
8 Replies
Any chance you can share some sample data and your R script so that we can try to replicate?
I think the problem is this bit below Im not sure why tho.
Error in check_input(x) :
Input must be a character vector of any length or a list of character
vectors, each of which has a length of 1.
Calls: %>% ... unnest_tokens -> unnest_tokens_ -> tokenfunc -> tf -> check_inputADDITIONAL INFO
Tried the same script as data source and it works perfectly! Just not as a Transform step within the query :(
Anonymous Have you got the package you're using in your script intalled. If the package is installed then you need to load that package in your script ie use library(packagename) at start of the script.
