Forum Discussion

hxkresl's avatar
hxkresl
Advocate III
8 years ago

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...
Need Help
hxkresl's avatar
hxkresl
Advocate III
8 years ago

nikitagrachev

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.

  • hxkresl's avatar
    hxkresl
    Advocate III
    8 years ago

    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?

    • boefraty's avatar
      boefraty
      Microsoft Employee
      8 years ago

      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

       

      • hxkresl's avatar
        hxkresl
        Advocate III
        8 years ago

        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.