Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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 that I haven't already to see the working funnel plot in power bi desktop?
Steps I took:
Having Aug 2017 version of Power BI Pro, I downloaded sample report, imported custom visual, installed R open 3.4.0 from Revolution Open, and pointed power bi desktop to folder having R version installed.
error:
R distribution
https://mran.revolutionanalytics.com/download/
Hello @hxkresl,
I have just faced the same issue. We'll contact a developer of this visual in order to invetigate deeper.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
Hello @hxkresl,
As a temporal workaround, go to RStudio or any other R console and run there:
>install.packages(“scales”)
and same for: "reshape", " ggplot2", "XML", "plotly", " htmlwidgets"
Nikita Grachev,
Team Leader
Microsoft Power BI Custom Visuals
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
Hello @hxkresl,
Have you installed all packages successfully from RStudio + R engine?
Nikita Grachev,
Team Leader
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com
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.
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: boefraty@microsoft.com or/and support team : pbircvsupport@microsoft.com
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 : boefraty@microsoft.com 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 @hxkresl,
By "clean" we just mean to delete all the files in the directory.
Did you try download CRAN R engine instead of MRO?
Do you have any other R custom visuals working on your computer?
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
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\
We'd recommend to contact pbircvsupport@microsoft.com and share issue details.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
3 | |
2 | |
1 | |
1 | |
1 |