Forum Discussion
rikBI
9 years agoHelper I
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...
Greg_Deckler
9 years agoCommunity Champion
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
9 years agoHelper V
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?