Forum Discussion

Helper I

9 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
9 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

Community Champion

9 years ago

Ah yes, according to the documentation, you need to use a gateway to refresh R. Might want to post this to Ideas if it is not already out there.

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-r-in-query-editor/

MAAbdullah47
Helper V
9 years ago
Thank You, I tested it in R studio it gives the following error:

> tempData <- mice(dataset,m=1,maxit=50,meth='pmm',seed=100)
Error in mice(dataset, m = 1, maxit = 50, meth = "pmm", seed = 100) :
No missing values found

Not sure if the same thing might happen in Power Bi or not?
MAAbdullah47
Helper V
9 years ago
Again On Power Bi I paste the same code:

DataSource.Error: ADO.NET: R script error.
Loading required package: methods
Warning message:
package 'mice' was built under R version 3.3.3
Error in mice(Orders_Basket_Table_1, m = 1, maxit = 50, meth = "pmm", :
object 'Orders_Basket_Table_1' not found
Execution halted
Details:
DataSourceKind=R

Note: Orders_Basket_Table_1 is the name of the dataset and it is surely available.

++++++++++++++++++

I tried as mentioned in the link:

DataSource.Error: ADO.NET: R script error.
Loading required package: methods
Warning message:
package 'mice' was built under R version 3.3.3
Error in `[.data.frame`(data, , jj) : undefined columns selected
Calls: mice -> sampler -> is.factor -> [ -> [.data.frame
Execution halted
Details:
DataSourceKind=R

Both of them not work ?!
- BhaveshPatel
  Super User
  7 years ago
  MAAbdullah47
  
  You can use Power Update to auto refresh your Power BI File Containing R script and schedule it to auto publish to PowerBI.com. It does not require gateway set up and works with minimal set up. It is also free for certain no of tasks.
  
  Download from
  
  www.PowerOnBI.com