Power BI R Visual License

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

 

Annunci

Rispondi

Inserisci i tuoi dati qui sotto o clicca su un'icona per effettuare l'accesso:

Logo WordPress.com

Stai commentando usando il tuo account WordPress.com. Chiudi sessione / Modifica )

Foto Twitter

Stai commentando usando il tuo account Twitter. Chiudi sessione / Modifica )

Foto di Facebook

Stai commentando usando il tuo account Facebook. Chiudi sessione / Modifica )

Google+ photo

Stai commentando usando il tuo account Google+. Chiudi sessione / Modifica )

Connessione a %s...