Forum Discussion

rikBI's avatar
rikBI
Helper I
10 years ago
Solved

Auto refresh R source

Hi All,   We are building a powerBI dashboard with R code that gets its data from an online service. This needs to be refreshed on an hourly basis. Powerbi can't refesh this source without the powe...
  • Anonymous's avatar
    Anonymous
    10 years ago

    Hi rikBI,

    I am afraid that you are not able to properly refresh R source without installing  personal gateway. According to the article, gateway is an essential requirement in order to set schedule refresh for R dataset.

    Thanks,
    Lydia Zhang

ankitpatira's avatar
ankitpatira
Community Champion
10 years ago

rikBI It is asking for gateway because R script gets executed against your local R server which will go to your online data source. If you absolutely can't install gateway then use Web connector to get data from online source within power bi desktop and it will refresh without needing gateway.

  • rikBI's avatar
    rikBI
    Helper I
    10 years ago

    Hi Ankit,

     

    Thank you for your suggestion. We tried that as well, but we need the R script to dynamically generate the URL.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      10 years ago

      Hi rikBI,

      I am afraid that you are not able to properly refresh R source without installing  personal gateway. According to the article, gateway is an essential requirement in order to set schedule refresh for R dataset.

      Thanks,
      Lydia Zhang