funnel plot, trouble viewing store.office sample report

nikitagrachev 

Still funnel plot sample report not working.

Error given:

Feedback Type:
Frown (Error)

Timestamp:
2017-08-28T18:50:05.8492406Z

Local Time:
2017-08-28T11:50:05.8492406-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:
414 MB

Private Memory:
290 MB

Peak Virtual Memory:
33.8 GB

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 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:
6817d94e-6c73-4068-9e32-fa8d0a79c8e0

Telemetry Enabled:
True

Model Default Mode:
Import

Snapshot Trace Logs:
C:\Users\v-hekres\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot1834763377.zip

Performance Trace Logs:
C:\Users\v-hekres\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:
Mon Aug 28 2017 11:50:04 GMT-0700 (Pacific Daylight Time)

Client Error Code:
ServiceErrorToClientError

Error Details:
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 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
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 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
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 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";

All packages installed without error except "plotly".  Output returned below:

--plotly
package ‘bindr’ successfully unpacked and MD5 sums checked
package ‘httpuv’ successfully unpacked and MD5 sums checked
package ‘xtable’ successfully unpacked and MD5 sums checked
package ‘sourcetools’ successfully unpacked and MD5 sums checked
package ‘mime’ successfully unpacked and MD5 sums checked
package ‘curl’ successfully unpacked and MD5 sums checked
package ‘openssl’ successfully unpacked and MD5 sums checked
package ‘yaml’ successfully unpacked and MD5 sums checked
Warning: unable to move temporary installation ‘C:\Users\myname\Documents\R\win-library\3.4\file477414f64045\yaml’ to ‘C:\Users\myname\Documents\R\win-library\3.4\yaml’
package ‘glue’ successfully unpacked and MD5 sums checked
package ‘tidyselect’ successfully unpacked and MD5 sums checked
package ‘assertthat’ successfully unpacked and MD5 sums checked
package ‘bindrcpp’ successfully unpacked and MD5 sums checked
Warning: unable to move temporary installation ‘C:\Users\myname\Documents\R\win-library\3.4\file477422ef1a4e\bindrcpp’ to ‘C:\Users\myname\Documents\R\win-library\3.4\bindrcpp’
package ‘pkgconfig’ successfully unpacked and MD5 sums checked
package ‘BH’ successfully unpacked and MD5 sums checked
package ‘plogr’ successfully unpacked and MD5 sums checked
package ‘shiny’ successfully unpacked and MD5 sums checked
package ‘httr’ successfully unpacked and MD5 sums checked
package ‘jsonlite’ successfully unpacked and MD5 sums checked
Warning: unable to move temporary installation ‘C:\Users\myname\Documents\R\win-library\3.4\file4774ada4dde\jsonlite’ to ‘C:\Users\myname\Documents\R\win-library\3.4\jsonlite’
package ‘base64enc’ successfully unpacked and MD5 sums checked
package ‘htmltools’ successfully unpacked and MD5 sums checked
package ‘htmlwidgets’ successfully unpacked and MD5 sums checked
package ‘tidyr’ successfully unpacked and MD5 sums checked
Warning: unable to move temporary installation ‘C:\Users\myname\Documents\R\win-library\3.4\file47742ed06e71\tidyr’ to ‘C:\Users\myname\Documents\R\win-library\3.4\tidyr’
package ‘hexbin’ successfully unpacked and MD5 sums checked
package ‘dplyr’ successfully unpacked and MD5 sums checked
package ‘tibble’ successfully unpacked and MD5 sums checked
package ‘crosstalk’ successfully unpacked and MD5 sums checked
package ‘purrr’ successfully unpacked and MD5 sums checked
package ‘data.table’ successfully unpacked and MD5 sums checked
package ‘plotly’ successfully unpacked and MD5 sums checked

The downloaded binary packages are in
C:\Users\myname\AppData\Local\Temp\RtmpOowAWz\downloaded_packages