Trying to load google trends package through R script

[jienkles]

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 function for 'toJSON' from package 'jsonlite' in package 'googleVis'
Error: No connection object has been created. Use 'gconnect()' first.
Execution halted

[Anonymous]

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]

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]

HI @jienkles,

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

Regards,
Xiaoxin Sheng