Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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 fo...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago
Hi there
Yep the data was a tweet dataset.
And yep I have the packages installed and loaded in r script

I copied and pasted the script in rstudio and it worked fine.

I got a feeling like it's tidytext package clashes with split. I'm no expert in R.

Thank you so much
Anonymous's avatar
Anonymous
Not applicable
9 years ago

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_input

 

ADDITIONAL INFO

Tried the same script as data source and it works perfectly! Just not as a Transform step within the query :(

  • v-micsh-msft's avatar
    v-micsh-msft
    Microsoft Employee
    9 years ago

    Hi Pedzila,

     

    What is your current situation?

    Could you please share about the R scripts that you used here?

    We will try to reproduce the error and see if we could find any helpful information with the scripts.

    I suspect it would work as the data source and not a transform step, should be caused by some functions used in the R scripts.

    Regards

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi

      THanks for replying

      R script below

       

      # 'dataset' holds the input data for this script
      library(tidytext)
      library(dplyr)

      title_words <- dataset %>%
      select(text) %>%
      unnest_tokens(Word, text)

       

      Data (one column called text)

       

      text

      #AttributeOwnership is exactly why @apple will always be #one! #apple #marketing #marketer #business #innovation #fb

      Can't wait to get my #Iphone5S!!! @apple

      Swapped my #galaxys2 for an #iPhone4S. After one day I'd say I'm an @apple convert!