Forum Discussion
funnel plot, trouble viewing store.office sample report
When I open the funnel plot demo https://store.office.com/powerbiaddininstallpage.aspx?rs=en-US&assetid=WA104381066 I expect to see the funnel graph but instead I get an error. What have I do to tha...
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 MB
package ‘plotly’ successfully unpacked and MD5 sums checked
The downloaded binary packages are in
C:\Users\myname\AppData\Local\Temp\RtmpIJC2Q4\downloaded_packages
I went to the location of install and found a zip file for all packages. Do these need to get unzipped?
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 packages
2) 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
regarding
1.
> .libPaths() [1] "C:/Users/v-hekres/Documents/R/win-library/3.4" [2] "C:/Program Files/R/R-3.4.1/library"
2. please provide link for how to Clean
I ran install.packages(c("scales","reshape","ggplot2","htmlwidgets","XML","plotly")) and it completed without error.
Hi there,
Getting below error while running the funnel plot using with some dummy data. Please have a look .
Thanks for the help!
Regards,
Ram
We'd recommend to contact [email protected] and share issue details.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
Hi ramm,
>5 min is not reasonable.
Did it happen for sample report in PBI desktop? On PC?
Can you please make sure to upgrade your PBI desktop and R engine on the PC.
And to do clean install of R packages. You may need to manualy remove conetnts of
c:\Users\userName\AppData\Local\Radio\Library\and
c:\Users\userName\Documents\R\win-library\3.x\
