Prerequisites - R environment setup with 'maps', 'geosphere', 'data.table' packages installed. Power BI desktop is configured for R installation. I have two sample csv datasets, one...
Published 10 years ago
Version 1.0
Blog Post
I was able to install the missing packages with Rstudio, (maps, geosphere, data.table)
But now got another error:
Feedback Type:
Frown (Error)
Timestamp:
2017-02-16T10:03:45.1555118Z
Local Time:
2017-02-16T11:03:45.1555118+01:00
Product Version:
2.43.4647.541 (PBIDesktop) (x86)
Release:
June, 2017
IE Version:
11.0.9600.18537
OS Version:
Microsoft Windows NT 6.1.7601 Service Pack 1 (x86 en-US)
CLR Version:
4.5.1 or later [Release Number = 378758]
Workbook Package Info:
1* - en-US, fastCombine: Disabled, runBackgroundAnalysis: True.
Peak Working Set:
457 MB
Private Memory:
398 MB
Peak Virtual Memory:
1.44 GB
Error Message:
R script error.
Loading required package: sp
Loading required package: methods
Error in order(dataset$count) : argument 1 is not a vector
Calls: [ -> [.data.frame -> order
Execution halted
User ID:
d4ec9cd4-f1b8-4176-a1b9-9e126e5d9e11
Session ID:
04872e61-a54a-4786-bee9-0a618e08d1e9
Telemetry Enabled:
True
Model Default Mode:
Import
Snapshot Trace Logs:
C:\Users\gisirei\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot1531301364.zip
Performance Trace Logs:
C:\Users\gisirei\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip
Enabled Preview Features:
PBI_RedShift
PBI_Impala
PBI_Snowflake
PBI_shapeMapVisualEnabled
PBI_allowBiDiCrossFilterInDirectQuery
PBI_clusteringEnabled
PBI_esriEnabled
Disabled DirectQuery Options:
DirectQuery_Unrestricted
Cloud:
GlobalCloud
Activity ID:
d542171f-e60c-5f8e-d07e-f61d782e4d9d
Time:
Thu Feb 16 2017 11:03:17 GMT+0100 (W. Europe Standard Time)
Version:
2.43.4647.541 (PBIDesktop)
Client Error Code:
ServiceErrorToClientError
Error Details:
R script error.
Loading required package: sp
Loading required package: methods
Error in order(dataset$count) : argument 1 is not a vector
Calls: [ -> [.data.frame -> order
Execution halted
Stack Trace:
Microsoft.PowerBI.ExploreServiceCommon.ScriptHandlerException: R script error.
Loading required package: sp
Loading required package: methods
Error in order(dataset$count) : argument 1 is not a vector
Calls: [ -> [.data.frame -> order
Execution halted
---> Microsoft.PowerBI.Radio.RScriptRuntimeException: R script error.
Loading required package: sp
Loading required package: methods
Error in order(dataset$count) : argument 1 is not a vector
Calls: [ -> [.data.frame -> order
Execution halted
at Microsoft.PowerBI.Radio.RScriptWrapper.RunScript(String originalScript, Int32 timeoutMs)
at Microsoft.PowerBI.Radio.RScriptWrapper.RunScriptFromText(String scriptPlainText, 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 Sheet3 = let
Source = Excel.Workbook(File.Contents("N:\Planning\Project Reports Area\PROJECT & PROCESSES\Yoann Albrecht\TRADE STOWAGE UTILIZATION\Trade Utilization Test_3.xlsx"), null, true),
Sheet3_Sheet = Source{[Item="Sheet3",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(Sheet3_Sheet),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Month", type text}, {"Service", type text}, {"Location", type text}, {"Commercial Region", type text}, {"Values", type text}, {"Total", type number}})
in
#"Changed Type";