rDataTable Custom Visual Error

[Anonymous]

Hello,

I saw this visual demonstrated on Microsoft's March video updated.   I installed R and downloaded this visual.  It loads into Power BI okay but when I add a field to the table, I get the following error.  I don't know how to use R and not sure if I have to configure something after installing it?

Any help is appreciated.

Thank you!

Feedback Type:
Frown (Error)

Timestamp:
2018-04-06T22:17:24.0857973Z

Local Time:
2018-04-06T16:17:24.0857973-06:00

Session ID:
c494795e-a89c-4f48-a8b5-735bb31ecb2d

Release:
March 2018

Product Version:
2.56.5023.1021 (PBIDesktop) (x64)

Error Message:
R script error.
Loading required package: XML
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE,  :
  there is no package called 'XML'
2: In libraryRequireInstall("XML") :
  *** The package: 'XML' was not installed ***
Loading required package: htmlwidgets
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE,  :
  there is no package called 'htmlwidgets'
2: In libraryRequireInstall("htmlwidgets") :
  *** The package: 'htmlwidgets' was not installed ***
Loading required package: DT
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE,  :
  there is no package called 'DT'
2: In libraryRequireInstall("DT") :
  *** The package: 'DT' was not installed ***
Error in datatable(Values, class = "cell-border compact stripe hover",  :
  could not find function "datatable"
Execution halted

OS Version:
Microsoft Windows NT 10.0.15063.0 (x64 en-US)

CLR Version:
4.7 or later [Release Number = 460798]

Peak Virtual Memory:
34 GB

Private Memory:
289 MB

Peak Working Set:
432 MB

IE Version:
11.850.15063.0

User ID:
d1c28060-ec73-4cf1-868b-2e3f56ebdbd2

Workbook Package Info:
1* - en-US, Query Groups: 0, fastCombine: Enabled, runBackgroundAnalysis: True.

Telemetry Enabled:
False

Model Default Mode:
Import

Snapshot Trace Logs:
C:\Users\caroleh\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot643705588.zip

Performance Trace Logs:
C:\Users\caroleh\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip

Enabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_EnableReportTheme
PBI_numericSlicerEnabled
CustomConnectors

Disabled Preview Features:
PBI_SpanishLinguisticsEnabled
PBI_AdobeAnalytics
PBI_qnaExplore
PBI_variationUIChange
PBI_customVisualsGallery
PBI_canvasTooltips

Enabled DirectQuery Options:
PBI_DirectQuery_Unrestricted

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

Formulas:

[Anonymous · Accepted solution]

Hello,

I found the answer on another forum post.

You need to go to the c:\Program Files\R\R.n.n.n(your version number)\bin.

Run R.exe

Type install.packages("XXX") where XXX is the name of the program that is not installed as per your error message.  When prompted to install a local package, say Yes and choose where you want to down load from.   Being in the US, I chose Texas.   I was only prompted for the first missing program and the next two installed smoothly.

I can now use the R DataTable in Power BI.