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
Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago

Any chance you can share some sample data and your R script so that we can try to replicate?

  • 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