Forum Discussion

jienkles's avatar
jienkles
Regular Visitor
8 years ago

Trying to load google trends package through R script

Hi There Ive tried to load google trends package through R in power bi and receive this error. Any help will be appreciated. thanks dean Details: "ADO.NET: R script error. Creating a generic fun...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi jienkles,

 

It seems like you need to sign in your account to enable google trends package, please refer to below link to know how to use it:

Download and plot Google Trends data with R

library(gtrendsR)
usr <- "<Google account email>"
psw <- "<Google account password>"
gconnect(usr, psw) 
lang_trend <- gtrends(c("data is", "data are"), res="week")
plot(lang_trend)

 

Regards,

Xiaoxin Sheng

jienkles's avatar
jienkles
Regular Visitor
8 years ago

Hi Anonymous

Initially i was on the wrong R package which didnt habe the option of google connect /jsonlite etc. then i changed it to the correct cran package and corrected my directory but then ggot an error message and googled it and it said on the google trends read me that this option was not available for google trends.  ie. (Due to recent changes to Google Trends API, the CRAN version of the package is no longer working. If you wan to continue to query Google Trends, you have to install the development version of the package. This will be soon deployed on CRAN). and that i should download the developer version. Once i did that i have the sam problem the above error message and gconnect not available. 

 

many thanks

 

dean

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    HI jienkles,

     

    I'd like to suggest you to contact to google support team to report this issue.

     

    Regards,
    Xiaoxin Sheng