topic Re: Personal Gateway for R script in Report Server

Personal Gateway for R script

MeghanDeWet — Thu, 09 Mar 2023 06:45:56 GMT

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.

The R code is used as a step in one of my tables in query editor, this is how it starts off:

new_dataset <- dataset
new_data <- data.frame(new_dataset)
HS <- new_data$"US_HTS_Code__c"
COO <- new_data$"Country_of_Origin2__c"
new_data$ADDFlag1 <-

Any guidance will be greatly appreciated, thanks so much!

Re: Personal Gateway for R script

DmitryKo — Thu, 09 Mar 2023 08:13:44 GMT

Gateway is cloud component, seems to be a wrong forum.

Re: Personal Gateway for R script

MeghanDeWet — Thu, 09 Mar 2023 08:19:20 GMT

Thanks for letting me know DmitryKo I will repost on the correct forum

Re: Personal Gateway for R script

MeghanDeWet — Thu, 09 Mar 2023 09:40:33 GMT

DmitryKo what exactly is the forum called? Can't seem to find one that realtes to "Cloud Component"

Re: Personal Gateway for R script

DmitryKo — Tue, 14 Mar 2023 16:42:38 GMT

gateway as architectural concept only applies to power bi service, cloud based and less secure usage model. It has nothing to do (and cannot be used) with Power BI Report Server.