Forum Discussion
funnel plot, trouble viewing store.office sample report
RStudio and R 3.4.1 are installed. In RStudio I installed all packages that you advised, and received errors with plotly. Error output provided in previous post.
- boefraty8 years agoMicrosoft Employee
Hi hxkresl,
The plotly package is known to have installation problems. I'd recommend yyou to retry installing it several times:
https://plotly-book.cpsievert.me/installation.html
If you still have trouble please contact me: [email protected] or/and support team : [email protected]
- hxkresl8 years agoAdvocate III
this time no issues with plotly install, but funnel plot giving this error (I think it is same error):
Feedback Type: Frown (Error) Timestamp: 2017-08-31T17:25:50.5451459Z Local Time: 2017-08-31T10:25:50.5451459-07:00 Product Version: 2.49.4831.521 (PBIDesktop) (x64) Release: August 2017 IE Version: 11.540.15063.0 OS Version: Microsoft Windows NT 10.0.15063.0 (x64 en-US) CLR Version: 4.6.2. or later [Release Number = 460798] Workbook Package Info: 1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True. Peak Working Set: 411 MB Private Memory: 305 MB Peak Virtual Memory: 33.8 GB Error Message: R script error. Loading required package: XML Loading required package: methods Warning message: package 'XML' was built under R version 3.4.1 Loading required package: htmlwidgets Warning message: package 'htmlwidgets' was built under R version 3.4.1 Loading required package: ggplot2 Error: package or namespace load failed for 'ggplot2' in loadNamespace(i, c(lib.loc, .libPaths()), versionCheck = vI[[i]]): there is no package called 'colorspace' Warning messages: 1: package 'ggplot2' was built under R version 3.4.1 2: In libraryRequireInstall("ggplot2") : *** The package: 'ggplot2' was not installed *** Loading required package: plotly Loading required package: ggplot2 Error: package or namespace load failed for 'ggplot2' in loadNamespace(i, c(lib.loc, .libPaths()), versionCheck = vI[[i]]): there is no package called 'colorspace' Failed with error: 'package 'ggplot2' could not be loaded' In addition: Warning messages: 1: package 'plotly' was built under R version 3.4.1 2: package 'ggplot2' was built under R version 3.4.1 Warning message: In libraryRequireInstall("plotly") : *** The package: 'plotly' was not installed *** Loading required package: scales Error: package or namespace load failed for 'scales' in loadNamespace(i, c(lib.loc, .libPaths()), versionCheck = vI[[i]]): there is no package called 'colorspace' Warning messages: 1: package 'scales' was built under R version 3.4.1 2: In libraryRequireInstall("scales") : *** The package: 'scales' was not installed *** Warning message: *** Some of the packages are missing ! *** Error in ggplot(aes(x = countValue[drawPoints], y = yAxis[drawPoints]), : could not find function "ggplot" Execution halted User ID: faf2a87b-8e06-437a-94f1-2e3b4e400f6d Session ID: 4a25846f-0fe2-4772-bd92-433b14b46664 Telemetry Enabled: True Model Default Mode: Import Snapshot Trace Logs: C:\Users\myname\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot1503845581.zip Performance Trace Logs: C:\Users\myname\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip Enabled Preview Features: PBI_EnableReportTheme Disabled Preview Features: PBI_shapeMapVisualEnabled PBI_numericSlicerEnabled PBI_SpanishLinguisticsEnabled PBI_daxTemplatesEnabled CustomConnectors Disabled DirectQuery Options: PBI_DirectQuery_Unrestricted Cloud: GlobalCloud Activity ID: null Time: Thu Aug 31 2017 10:25:39 GMT-0700 (Pacific Daylight Time) Client Error Code: ServiceErrorToClientError Error Details: R script error. Loading required package: XML Loading required package: methods Warning message: package 'XML' was built under R version 3.4.1 Loading required package: htmlwidgets Warning message: package 'htmlwidgets' was built under R version 3.4.1 Loading required package: ggplot2 Error: package or namespace load failed for 'ggplot2' in loadNamespace(i, c(lib.loc, .libPaths()), versionCheck = vI[[i]]): there is no package called 'colorspace' Warning messages: 1: package 'ggplot2' was built under R version 3.4.1 2: In libraryRequireInstall("ggplot2") : *** The package: 'ggplot2' was not installed *** Loading required package: plotly Loading required package: ggplot2 Error: package or namespace load failed for 'ggplot2' in loadNamespace(i, c(lib.loc, .libPaths()), versionCheck = vI[[i]]): there is no package called 'colorspace' Failed with error: 'package 'ggplot2' could not be loaded' In addition: Warning messages: 1: package 'plotly' was built under R version 3.4.1 2: package 'ggplot2' was built under R version 3.4.1 Warning message: In libraryRequireInstall("plotly") : *** The package: 'plotly' was not installed *** Loading required package: scales Error: package or namespace load failed for 'scales' in loadNamespace(i, c(lib.loc, .libPaths()), versionCheck = vI[[i]]): there is no package called 'colorspace' Warning messages: 1: package 'scales' was built under R version 3.4.1 2: In libraryRequireInstall("scales") : *** The package: 'scales' was not installed *** Warning message: *** Some of the packages are missing ! *** Error in ggplot(aes(x = countValue[drawPoints], y = yAxis[drawPoints]), : could not find function "ggplot" Execution halted Stack Trace: Microsoft.PowerBI.ExploreServiceCommon.ScriptHandlerException: R script error. Loading required package: XML Loading required package: methods Warning message: package 'XML' was built under R version 3.4.1 Loading required package: htmlwidgets Warning message: package 'htmlwidgets' was built under R version 3.4.1 Loading required package: ggplot2 Error: package or namespace load failed for 'ggplot2' in loadNamespace(i, c(lib.loc, .libPaths()), versionCheck = vI[[i]]): there is no package called 'colorspace' Warning messages: 1: package 'ggplot2' was built under R version 3.4.1 2: In libraryRequireInstall("ggplot2") : *** The package: 'ggplot2' was not installed *** Loading required package: plotly Loading required package: ggplot2 Error: package or namespace load failed for 'ggplot2' in loadNamespace(i, c(lib.loc, .libPaths()), versionCheck = vI[[i]]): there is no package called 'colorspace' Failed with error: 'package 'ggplot2' could not be loaded' In addition: Warning messages: 1: package 'plotly' was built under R version 3.4.1 2: package 'ggplot2' was built under R version 3.4.1 Warning message: In libraryRequireInstall("plotly") : *** The package: 'plotly' was not installed *** Loading required package: scales Error: package or namespace load failed for 'scales' in loadNamespace(i, c(lib.loc, .libPaths()), versionCheck = vI[[i]]): there is no package called 'colorspace' Warning messages: 1: package 'scales' was built under R version 3.4.1 2: In libraryRequireInstall("scales") : *** The package: 'scales' was not installed *** Warning message: *** Some of the packages are missing ! *** Error in ggplot(aes(x = countValue[drawPoints], y = yAxis[drawPoints]), : could not find function "ggplot" Execution halted ---> Microsoft.PowerBI.Radio.RScriptRuntimeException: R script error. Loading required package: XML Loading required package: methods Warning message: package 'XML' was built under R version 3.4.1 Loading required package: htmlwidgets Warning message: package 'htmlwidgets' was built under R version 3.4.1 Loading required package: ggplot2 Error: package or namespace load failed for 'ggplot2' in loadNamespace(i, c(lib.loc, .libPaths()), versionCheck = vI[[i]]): there is no package called 'colorspace' Warning messages: 1: package 'ggplot2' was built under R version 3.4.1 2: In libraryRequireInstall("ggplot2") : *** The package: 'ggplot2' was not installed *** Loading required package: plotly Loading required package: ggplot2 Error: package or namespace load failed for 'ggplot2' in loadNamespace(i, c(lib.loc, .libPaths()), versionCheck = vI[[i]]): there is no package called 'colorspace' Failed with error: 'package 'ggplot2' could not be loaded' In addition: Warning messages: 1: package 'plotly' was built under R version 3.4.1 2: package 'ggplot2' was built under R version 3.4.1 Warning message: In libraryRequireInstall("plotly") : *** The package: 'plotly' was not installed *** Loading required package: scales Error: package or namespace load failed for 'scales' in loadNamespace(i, c(lib.loc, .libPaths()), versionCheck = vI[[i]]): there is no package called 'colorspace' Warning messages: 1: package 'scales' was built under R version 3.4.1 2: In libraryRequireInstall("scales") : *** The package: 'scales' was not installed *** Warning message: *** Some of the packages are missing ! *** Error in ggplot(aes(x = countValue[drawPoints], y = yAxis[drawPoints]), : could not find function "ggplot" Execution halted at Microsoft.PowerBI.Radio.RScriptWrapper.RunScript(String originalScript, Int32 timeoutMs) at Microsoft.PowerBI.Client.Windows.R.RScriptHandler.GenerateVisual(ScriptHandlerOptions options) --- End of inner exception stack trace --- at Microsoft.PowerBI.Client.Windows.R.RScriptHandler.GenerateVisual(ScriptHandlerOptions options) at Microsoft.PowerBI.ExploreServiceCommon.ScriptVisualCommandFlow.RunInternal(Stream dataShapeResultStream, QueryBindingDescriptor& bindingDescriptor) at Microsoft.PowerBI.ExploreServiceCommon.ScriptVisualCommandFlow.Run(Stream dataShapeResultStream, QueryBindingDescriptor& bindingDescriptor) at Microsoft.PowerBI.ExploreHost.SemanticQuery.ExecuteSemanticQueryFlow.TransformDataShapeResult(QueryCommand transformCommand, String dataShapeId, SemanticQueryDataShapeCommand command, Stream dataShapeResultStream, QueryBindingDescriptor& bindingDescriptor) at Microsoft.PowerBI.ExploreHost.SemanticQuery.ExecuteSemanticQueryFlow.ProcessAndWriteDataQuery(IQueryResultDataWriter queryResultDataWriter, DataShapeGenerationContext dsqGenContext, EntityDataModel model, DataQuery query, ServiceErrorStatusCode& serviceErrorStatusCode) at Microsoft.PowerBI.ExploreHost.SemanticQuery.ExecuteSemanticQueryFlow.ProcessAndWriteSemanticQueryCommands(IQueryResultsWriter queryResultsWriter, ExecuteSemanticQueryRequest request, IConceptualSchema conceptualSchema, EntityDataModel model) DPI Scale: 100% Supported Services: Power BI Formulas: section Section1; shared #"Bowel cancer mortality by region" = let Source = Web.Page(Web.Contents("https://www.theguardian.com/commentisfree/2011/oct/28/bad-science-diy-data-analysis")), Data0 = Source{0}[Data], #"Changed Type" = Table.TransformColumnTypes(Data0,{{"Area", type text}, {"Rate", type number}, {"Population", Int64.Type}, {"Number", Int64.Type}}), #"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{"Population", "Population"}, {"Number", "Number"}}) in #"Renamed Columns";Here's output of plotly:
> install.packages("plotly")
Installing package into ‘C:/Users/myname/Documents/R/win-library/3.4’
(as ‘lib’ is unspecified)
--- Please select a CRAN mirror for use in this session ---
trying URL 'https://cran.cnr.berkeley.edu/bin/windows/contrib/3.4/plotly_4.7.1.zip'
Content type 'application/zip' length 1160539 bytes (1.1 MB)
downloaded 1.1 MBpackage ‘plotly’ successfully unpacked and MD5 sums checked
The downloaded binary packages are in
C:\Users\myname\AppData\Local\Temp\RtmpIJC2Q4\downloaded_packagesI went to the location of install and found a zip file for all packages. Do these need to get unzipped?
- boefraty8 years agoMicrosoft Employee
Hi hxkresl,
From some reason your R is blind to installed R packages. All the installed packages are suppose to be in 3 folders:
1) c:\Program Files\R\R-3.4.0\library\ - core packages2) c:\Users\username\Documents\R\win-library\3.4\ - installed via RStudio
3) c:\Users\username\AppData\Local\Radio\Library\ - installed via Power BI with auto-install mode.
We have temporal bug and auto-install mode is not working. Our team works to resolve it for next version.
a) Please check if you see folder #2 in RStudio if you run command
.libPaths()b) Clean folders #2, #3 and run in RStudio
>install.packages(c("scales","reshape","ggplot2","htmlwidgets","XML","plotly"))c) If it does not help, please contact me : [email protected] and we will resolve it via skype