R Script and auto refresh

[MeghanDeWet]

Hi there,

I have used an R script in my BI Dashboard, published it and set an auto refresh with a personal gateway.

The personal gateway is on and ready to use, the auto refresh works with no error but the column that refrences the R code does not show the correct data. The column is meant to show Trues and falses but it only shows False. 

When I refresh in desktop it works perfectly and the column displays the correct info.

I think I am missing something in the personal gateway or in the actual R code but I have read everything I can find on this and just can't seem to get it right. I am new to using R in BI so the whole process has been trial and error but it is just odd that it works in desktop but not service. 

Any guidance will be greatly appreciated, thanks so much!

[TomMartens]

Hey @MeghanDeWet ,

assuming that the personal gateway is installed on a different machine the same versions of R and the same version of the packages must be installed on the gateway machine.

Hopefully, this helps to tackle your challenge.

Regards,

Tom

[MeghanDeWet]

Hi @TomMartens, thanks for your response, I really appreciate it!

The personal gateway is on the same machine as the dashboard and R script...Any ideas what could be going on?