Personal Gateway for R script

[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. 

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!

[DmitryKo]

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

[MeghanDeWet]

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

[DmitryKo]

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.

[MeghanDeWet]

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