Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

R visuals are no longer shown - yet this was working.

All packages were automatically downloaded and installed by Power BI when attempting to display the "clustering" visual. However whilst this did work ,now the report no longer works. It does NOT offer an option to correct the problem. The error message under see details is shown below. I have highlighed in bold there is no package called 'shiny', yet this should be part of the automatic download.

 

 

Feedback Type:
Frown (Error)

Timestamp:
2018-07-02T14:18:22.1728319Z

Local Time:
2018-07-02T15:18:22.1728319+01:00

Session ID:
6abc2e1f-6feb-42e3-afd1-cc38c5c4d7fd

Release:
June 2018

Product Version:
2.59.5135.781 (PBIDesktop) (x64)

Error Message:
R script error.
Loading required package: XML
Warning message:
package 'XML' was built under R version 3.3.3
Loading required package: htmlwidgets
Warning message:
package 'htmlwidgets' was built under R version 3.3.3
Loading required package: base64enc
Loading required package: nloptr
Loading required package: seriation

Attaching package: 'seriation'

The following object is masked from 'package:lattice':

panel.lines

Loading required package: NbClust
Loading required package: cluster
Loading required package: car
Loading required package: carData
Loading required package: scales
Loading required package: fpc
Loading required package: mclust
Package 'mclust' version 5.4
Type 'citation("mclust")' for citing this R package in publications.
Loading required package: apcluster

Attaching package: 'apcluster'

The following object is masked from 'package:stats':

heatmap

Loading required package: vegan
Loading required package: permute

Attaching package: 'permute'

The following object is masked from 'package:seriation':

permute

This is vegan 2.5-1
Loading required package: Redmonder
Loading required package: caTools

Attaching package: 'caTools'

The following objects are masked from 'package:base64enc':

base64decode, base64encode

Loading required package: ggplot2
Loading required package: plotly

Attaching package: 'plotly'

The following object is masked from 'package:ggplot2':

last_plot

The following object is masked from 'package:stats':

filter

The following object is masked from 'package:graphics':

layout

We recommend that you use the dev version of ggplot2 with `ggplotly()`
Install it with: `devtools::install_github('hadley/ggplot2')`
Error in loadNamespace(i, c(lib.loc, .libPaths()), versionCheck = vI[[i]]) :
there is no package called 'shiny'
Calls: plotly_build ... tryCatch -> tryCatchList -> tryCatchOne -> <Anonymous>
Execution halted


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

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

Peak Virtual Memory:
34.4 GB

Private Memory:
336 MB

Peak Working Set:
507 MB

IE Version:
11.1155.15063.0

User ID:
acdee55d-344d-4655-9573-7c144478f596

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

Telemetry Enabled:
True

AS Live Connection:
True

Performance Trace Logs:
C:\Users\IKhan\Microsoft\Power BI Desktop Store App\PerformanceTraces.zip

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_EnableReportTheme
PBI_newFromWeb
PBI_SpanishLinguisticsEnabled
CustomConnectors
PBI_qnaExplore
PBI_variationUIChange
PBI_canvasTooltips
PBI_showIncrementalRefreshPolicy

Disabled DirectQuery Options:
PBI_DirectQuery_Unrestricted
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

Formulas:


section Section1;

Status: Needs Info
Comments
v-qiuyu-msft
Community Support

Hi @inayatkhan,

 

Please click on Sample Report inside of this page to download the pbix file. Then open it in Power BI desktop, it will prompt you enable Enable Script Visuals, click Enable. Then it will prompt you install packages, click Install. Check if all required packages can be installed successfully and clustering visual can display fine. 

 

Best Regards,
Qiuyun Yu 

Vicky_Song
Impactful Individual
Status changed to: Needs Info
 
inayatkhan
Frequent Visitor

Hi, Tried the sample report, it did NOT prompt for any downloads ( I had previously downloaded all code when prompted on my own reports). It then displayed the error mesages I have seen in my own reports about unable to locate methods and modules in this this case ggplot the essential R drawing package.

 

Failed Clustering with R addins.PNG

 

 

Below is the error message that is in the Can't display the visual box.

 

 

Feedback Type:
Frown (Error)

Timestamp:
2018-07-03T07:56:16.8013608Z

Local Time:
2018-07-03T08:56:16.8013608+01:00

Session ID:
e299e4a0-26a2-4d26-a88a-94859121a21d

Release:
March 2018

Product Version:
2.56.5023.1043 (PBIDesktop) (x64)

Error Message:
R script error.
Loading required package: XML
Error: package or namespace load failed for 'XML':
package 'XML' was installed by an R version with different internals; it needs to be reinstalled for use with this R version
Warning message:
In libraryRequireInstall("XML") :
*** The package: 'XML' was not installed ***
Loading required package: htmlwidgets
Error: package or namespace load failed for 'htmlwidgets':
package 'htmltools' was installed by an R version with different internals; it needs to be reinstalled for use with this R version
Warning message:
In libraryRequireInstall("htmlwidgets") :
*** The package: 'htmlwidgets' was not installed ***
Loading required package: base64enc
Error: package or namespace load failed for 'base64enc':
package 'base64enc' was installed by an R version with different internals; it needs to be reinstalled for use with this R version
Warning message:
In libraryRequireInstall("base64enc") :
*** The package: 'base64enc' was not installed ***
Loading required package: nloptr
Error: package or namespace load failed for 'nloptr':
package 'nloptr' was installed by an R version with different internals; it needs to be reinstalled for use with this R version
Loading required package: seriation
Error: package or namespace load failed for 'seriation':
package 'seriation' was installed by an R version with different internals; it needs to be reinstalled for use with this R version
Loading required package: NbClust
Loading required package: cluster
Loading required package: car
Loading required package: carData
Error: package or namespace load failed for 'car':
package 'data.table' was installed by an R version with different internals; it needs to be reinstalled for use with this R version
Loading required package: scales
Error: package or namespace load failed for 'scales':
package 'scales' was installed by an R version with different internals; it needs to be reinstalled for use with this R version
Loading required package: fpc
Error: package or namespace load failed for 'fpc':
package 'mclust' was installed by an R version with different internals; it needs to be reinstalled for use with this R version
Loading required package: mclust
Error: package or namespace load failed for 'mclust':
package 'mclust' was installed by an R version with different internals; it needs to be reinstalled for use with this R version
Loading required package: apcluster
Error: package or namespace load failed for 'apcluster':
package 'apcluster' was installed by an R version with different internals; it needs to be reinstalled for use with this R version
Loading required package: vegan
Loading required package: permute
Loading required package: lattice
Error: package or namespace load failed for 'vegan':
package 'vegan' was installed by an R version with different internals; it needs to be reinstalled for use with this R version
Loading required package: Redmonder
Loading required package: caTools
Error: package or namespace load failed for 'caTools':
package 'caTools' was installed by an R version with different internals; it needs to be reinstalled for use with this R version
Loading required package: ggplot2
Error: package or namespace load failed for 'ggplot2':
package 'scales' was installed by an R version with different internals; it needs to be reinstalled for use with this R version
Loading required package: plotly
Loading required package: ggplot2
Error: package or namespace load failed for 'ggplot2':
package 'scales' was installed by an R version with different internals; it needs to be reinstalled for use with this R version
Failed with error: 'package 'ggplot2' could not be loaded'
Error in ggplot(dfPoints, aes(x = xx, y = yy, colour = labels, labels = labels, :
could not find function "ggplot"
Calls: ggplotPoints
Execution halted


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

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

Peak Virtual Memory:
34.1 GB

Private Memory:
277 MB

Peak Working Set:
385 MB

IE Version:
11.1155.15063.0

User ID:
743bd204-2236-40e6-9263-f8be51b2cdde

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

Telemetry Enabled:
True

Model Default Mode:
Import

Snapshot Trace Logs:
C:\Users\IKhan\AppData\Local\Microsoft\Power BI Desktop SSRS\FrownSnapShot399730513.zip

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

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_EnableReportTheme
PBI_numericSlicerEnabled
PBI_SpanishLinguisticsEnabled
CustomConnectors
PBI_AdobeAnalytics
PBI_qnaExplore
PBI_variationUIChange
PBI_customVisualsGallery
PBI_canvasTooltips

Disabled DirectQuery Options:
PBI_DirectQuery_Unrestricted
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI Report Server, Power BI

Formulas:


section Section1;

shared kmeans_data = let
Source = Csv.Document(File.Contents("C:\Users\boefraty\projects\PBI\R\custom_R_visuals\kmeans_data.csv"),[Delimiter=",", Columns=11, Encoding=1252, QuoteStyle=QuoteStyle.None]),
#"Promoted Headers" = Table.PromoteHeaders(Source),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Area", Int64.Type}, {"Frost", Int64.Type}, {"Illiteracy", type number}, {"HS Grad", type number}, {"Income", Int64.Type}, {"Life Exp", type number}, {"Murder", type number}, {"Population", Int64.Type}, {"Population Size", type text}, {"State.Name", type text}, {"StateAbb", type text}}),
#"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"State.Name"})
in
#"Removed Columns";