The new Feature of Power BI R visual have three type of limitation:
- Power BI version
- Type of R script
- R use Limitation
I ‘ll try to resume this limitations to give you more information to use correclty R visual on Power bI
Power Bi License
R visuals require a Power BI Pro license to render in reports, refresh, filter and cross-filter. The following table describes R visuals capabilities based on licensing.
R Limitation
R visuals in the Power BI service have a few limitations:
- Data size limitations,only the top 150,000 rows are used and a message is displayed on the image.
- Calculation time limitation – if an R visual calculation exceeds 60 seconds the script times out, resulting in an error.
- R visuals is not interactive and does not support tool tips.
- You cannot click on elements in the R visual in order to cross filter other elements.
- R visuals are currently not supported for the Time data type. Please use Date/Time instead.
- R Visuals do not display when using Publish to web.
- R visuals currently do not print with dashboard and reports printing
- R visuals are currently not supported in the DirectQuery mode of Analysis Services
Type of R script:
The following R packages are currently supported in the Power BI service. These packages are in alphabetical order.
- abc
abc.data
acepack
actuar
ade4
AdMit
aod
ape
aplpack
approximator
arm
arules
arulesViz
assertthat
AzureML
BACCO
BaM
BAS
base64enc
BDA
bayesm
bayesmix
bayesQR
bayesSurv
BayesTree
BayHaz
bbemkr
BCBCSF
BCE
bclust
BenfordTests
bisoreg
bit
bit64
bitops
BMA
Bmix
BMS0
bnlearn,
boa
boot
bootstrap
bqtl
BradleyTerry2
brew
brglm,
bspec
bspmma
BVS
C50
calibrator
car
caret,
catnet
caTools
cclust
class
clue
cluster
clusterSim
coda
coin
CORElearn
corpcor
corrplot
crayon
cslogistic
cubature
cvTools
data.table
date
dclone
deal
Deducer
DeducerExtras
deepnet
deldir
dendextend
DEoptimR
deSolve
devtools
DiagrammeR
dichromat
digest
distrom
dlm
DMwR
doParallel
doSNOW
dplyr
DPpackage
dse
dtw
e1071
earth
EbayesThresh
ebdbNet
ellipse
emulator
ensembleBMA
entropy
EvalEst
evaluate
evdbayes
exactLoglinTest
expm
extremevalues
FactoMineR
factorQR
faoutlier
fBasics
fields
filehash
fitdistrplus
flashClust
FME
foreach
forecast
Formula
fracdiff
fTrading
gam
gamlr
gclus
gdata
gee
gender
genetics
geoRglm
geosphere
GGally
ggdendro
ggmap
ggmcmc
ggplot2
ggthemes
glmmBUGS
glmnet
gmodels
gmp
gnm
GPArotation - gridBase
gridExtra
growcurves
grpreg
gss
gsubfn
gtable
gtools
haplo.stats
hash
hbsae
hdrcde
heavy
HH
HI
Hmisc
HSAUR
ifultools
igraph
intervals
iplots
ipred
irlba
irr
iterators
jpeg
jsonlite
kernlab
KernSmooth
KFKSDS
kinship2
kknn
klaR
knitr
ks
labeling
lars
lattice
latticeExtra
lava
lavaan
lazyeval
leaps
LearnBayes
LiblineaR
limSolve
lme4
lmm
lmtest
locfit
locpol
LogicReg
longitudinalData
lsa
LSAfun
lubridate
magic
magrittr
mapdata
mapproj
maps
maptree
MASS
MasterBayes
Matrix
matrixcalc
MatrixModels
maxent
maxLik
mboost
MCMCpack
mda
memoise
mi
mice
microbenchmark
mime
miniCRAN
misc3d
miscF
miscTools
mixtools
mlbench
mnormt
MNP
modeltools
mombf
monomvn
MSBVAR
msm
multcomp
munsell - mvtnorm
ncvreg
nlme
nloptr
NLP
NMF
nnet
nnls
numbers
numDeriv
openNLP
openNLPdata
OutlierDC
pacbpred
party
partykit
PAWL
pbivnorm
pcaPP
pdc
PerformanceAnalytics
plotmo
plotrix
pls
plyr
png
polynom
PottsUtils
predmixcor
PresenceAbsence
profdpm
proto
proxy
pryr
pscl
psych
qap
qdap
qdapRegex
quadprog
quantreg
qvcalc
R.oo
.utils
ramps
RandomFieldsUtils
RColorBrewer
Rcpp
RcppArmadillo
RcppEigen
registry
relimp
reshape
reshape2
rgdal
rgl
RGraphics
rjags
rjson
RJSONIO
Rmpfr
rmN - robustbase
ROCR
rpart.plot
rrcov
rscproxy
RSGHB
RTextTools
rworldmap
SampleSizeMeans
SampleSizeProportions
sbgcop
scales
scatterplot3d
sciplot
segmented
seriation
setRNG
sfsmisc
SimpleTable
SIS
skmeans
slam
smoothSurv
sna
snow
SnowballC
snowFT
sp
spacetime
spam
SparseM
spatial
spBayes
spdep
spikeslab
splancs
spls
spTimer
sqldf
sROC
stabledist
stabs
stepPlr
stringdist
stringr
stsm
stsm.class
survival
tau
tcltk2
tensorA
textcat
textir
tfplot
TH.data
tidyr
timeDate
timeSeries
tm
topicmodels
tree
TSclust
tseries
tsfa
tsoutliers
TSP
TTR
vcd
venneuler
VGAM
VIM
whisker
wordcloud
xgboost
XML
xts
yaml
zipfR
zoo
The following R packages are planned to be supported soon in the Power BI service. These packages are in alphabetical order.
AER, base64, beanplot, broom, calibrate, circlize, corrgram, descr, dynlm, flexclust, flexmix, fpc, futile.options, gdtools, ggm, ggrepel, gstat, lambda.r, lsmeans, MAPA, mixOmics, msm, pixmap, plot3D, pracma, qcc, qgraph, R.rsp, rasterVis, rex, shape, sjPlot, sm, spatstat, statmod, survey, threejs, tibble, tiff, TSA, tsintermittent, vars, VIM, vioplot