Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I'm a begginer in Power Bi Desktop and I'm trying to run a simple R Script ...
I click on "R", drag Sales and Average Ticket and on the script I just wrote
plot(dataset)
Below I posted the error mensage.
Thank you
Riad
The error mensage is
Feedback Type:
Frown (Error)
Timestamp:
2017-10-10T12:09:09.2061830Z
Local Time:
2017-10-10T09:09:09.2061830-03:00
Product Version:
2.50.4859.502 (PBIDesktop) (x64)
Release:
September 2017
IE Version:
11.0.9600.17498
OS Version:
Microsoft Windows NT 6.3.9600.0 (x64 pt-BR)
CLR Version:
4.5.2 or later [Release Number = 379893]
Workbook Package Info:
1* - pt-BR, Query Groups: 1, fastCombine: Disabled, runBackgroundAnalysis: True.
Peak Working Set:
362 MB
Private Memory:
263 MB
Peak Virtual Memory:
1.83 GB
Error Message:
An unexpected error occurred while processing the R script.
Error details:
Running the R script encountered the following error:
Failed to retrieve error code string from System ->317
Make sure R is properly installed on your machine.
User ID:
f5122281-bee6-4200-9817-5580df60541f
Session ID:
4db34e72-3394-4284-add0-db322187266e
Telemetry Enabled:
True
Model Default Mode:
Import
Snapshot Trace Logs:
C:\Users\User\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot1516512280.zip
Performance Trace Logs:
C:\Users\User\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip
Enabled Preview Features:
PBI_EnableReportTheme
PBI_daxTemplatesEnabled
Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_numericSlicerEnabled
PBI_SpanishLinguisticsEnabled
CustomConnectors
Disabled DirectQuery Options:
PBI_DirectQuery_Unrestricted
Cloud:
GlobalCloud
Activity ID:
null
Time:
Tue Oct 10 2017 09:09:03 GMT-0300 (Hora oficial do Brasil)
Client Error Code:
ServiceErrorToClientError
Error Details:
An unexpected error occurred while processing the R script.
Error details:
Running the R script encountered the following error:
Failed to retrieve error code string from System ->317
Make sure R is properly installed on your machine.
Stack Trace:
Microsoft.PowerBI.ExploreServiceCommon.ScriptHandlerException: An unexpected error occurred while processing the R script.
Error details:
Running the R script encountered the following error:
Failed to retrieve error code string from System ->317
Make sure R is properly installed on your machine. ---> Microsoft.PowerBI.Radio.RUnexpectedException: An unexpected error occurred while processing the R script.
Error details:
Running the R script encountered the following error:
Failed to retrieve error code string from System ->317
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 Cadastrolojas = let
Source = Excel.Workbook(File.Contents("C:\Users\User\Dropbox\Café\Fechamento\Operações Próprias\Fechamento\2017\basecafepowerbi.xlsx"), null, true),
Cadastrolojas_Sheet = Source{[Item="Cadastrolojas",Kind="Sheet"]}[Data],
#"Changed Type" = Table.TransformColumnTypes(Cadastrolojas_Sheet,{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}}),
#"Promoted Headers" = Table.PromoteHeaders(#"Changed Type", [PromoteAllScalars=true]),
#"Changed Type1" = Table.TransformColumnTypes(#"Promoted Headers",{{"Nome Sistema", type text}, {"Loja", type text}, {"Marca", type text}})
in
#"Changed Type1";
shared Cadastroprodutosvenda = let
Source = Excel.Workbook(File.Contents("C:\Users\User\Dropbox\Café\Fechamento\Operações Próprias\Fechamento\2017\basecafepowerbi.xlsx"), null, true),
Cadastroprodutosvenda_Sheet = Source{[Item="Cadastroprodutosvenda",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(Cadastroprodutosvenda_Sheet, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Descrição do Produto", type text}, {"Unid.", type text}, {"Grupo", type text}, {"Classificação", type text}, {"Linha de Produto", type any}, {"Preço Venda", type number}, {"NCM (Franqueador)", Int64.Type}, {"Marca", type text}, {"Código Produto & Marca", type text}, {"Grupo (ajustado)", type text}})
in
#"Changed Type";
shared receitaloja = let
Source = Excel.Workbook(File.Contents("C:\Users\User\Dropbox\Café\Fechamento\Operações Próprias\Fechamento\2017\basecafepowerbi.xlsx"), null, true),
receitaloja_Sheet = Source{[Item="receitaloja",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(receitaloja_Sheet, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Marca", type text}, {"Loja", type text}, {"mês/ano", type date}, {"Ano", Int64.Type}, {"R.Bruta", type number}, {"Desconto", type number}, {"Cortesia", type number}, {"Cupons", Int64.Type}, {"Qtde. Produtos Vendidos", Int64.Type}})
in
#"Changed Type";
shared receitaproduto = let
Source = Excel.Workbook(File.Contents("C:\Users\User\Dropbox\Café\Fechamento\Operações Próprias\Fechamento\2017\basecafepowerbi.xlsx"), null, true),
receitaproduto_Sheet = Source{[Item="receitaproduto",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(receitaproduto_Sheet, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Marca", type text}, {"Loja", type text}, {"mês/ano", type date}, {"Ano", Int64.Type}, {"Código Produto & Marca", type text}, {"Qtde. Produtos Vendidos", Int64.Type}, {"R.Bruta", type number}})
in
#"Changed Type";
shared #"Errors in receitaloja" = let
Source = receitaloja,
#"Added Index" = Table.AddIndexColumn(Source, "Row Number" ,1),
#"Kept Errors" = Table.SelectRowsWithErrors(#"Added Index", {"Marca", "Loja", "mês/ano", "Ano", "R.Bruta", "Desconto", "Cortesia", "Cupons", "Qtde. Produtos Vendidos"}),
#"Reordered Columns" = Table.ReorderColumns(#"Kept Errors", {"Row Number", "Marca", "Loja", "mês/ano", "Ano", "R.Bruta", "Desconto", "Cortesia", "Cupons", "Qtde. Produtos Vendidos"})
in
#"Reordered Columns"
;
Solved! Go to Solution.
Hi @riadorra,
Before you create a R visual in Power BI desktop, you need to install R, configure and enable it, have you installed it? If you haven't please review the detailed steps in this blog: Create Power BI visuals using R.
After configure it well, I create a R vsiual in my local computer, select two columns as values, it works fine as follows.
Best Regards,
Angelia
Hi @riadorra,
Before you create a R visual in Power BI desktop, you need to install R, configure and enable it, have you installed it? If you haven't please review the detailed steps in this blog: Create Power BI visuals using R.
After configure it well, I create a R vsiual in my local computer, select two columns as values, it works fine as follows.
Best Regards,
Angelia
Hi Angelia,
thank you very much for your help.
Riad
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |