Open Side Menu
Skip to contentBrand Logo
Forums
Inspiration
Ideas
Communities
Blogs
Learning
Support
RegisterSign In
  1. Microsoft Fabric Community
  2. Power BI forums
  3. Galleries
  4. R Script Showcase
Sharon's avatar
Sharon
Microsoft Employee
10 years ago

Forecasting

Description Forecasting is used to predict next points in time series data sets. The prediction in this example is based on trend and seasonality.     Prerequisites (The sample .pbix file...
Forecasting Showcase.pbix635 KB
ScriptInstallPackagesWithWorkaroundsForecast.R1 KB
Advanced Analytics Visualizations
HMonteiro's avatar
HMonteiro
New Member
10 years ago

Hi, great piece of software,

 

All other models work, except this one, probably with the ts code part.

 

Posting the error message file here:

 

Error Message:

Erro de script do R.
Loading required package: scales
Loading required package: forecast
Loading required package: zoo

Attaching package: 'zoo'

The following objects are masked from 'package:base':

as.Date, as.Date.numeric

Loading required package: timeDate
Loading required package: methods
This is forecast 7.1

Error in if (frequency > 1 && abs(frequency - round(frequency)) < ts.eps) frequency <- round(frequency) :
missing value where TRUE/FALSE needed
Calls: ts
Execution halted


Stack Trace:

 

Invocation Stack Trace:

 

ID de atividade
e5ab37b4-ff68-4eeb-9ac7-d3cc346b8037

Hora
Fri Aug 19 2016 00:14:08 GMT+0100 (Hora de Verão de GMT)

Versão
2.37.4464.361 (PBIDesktop)

Client Error Code
ServiceErrorToClientError

Error Details
Erro de script do R.
Loading required package: scales
Loading required package: forecast
Loading required package: zoo

Attaching package: 'zoo'

The following objects are masked from 'package:base':

as.Date, as.Date.numeric

Loading required package: timeDate
Loading required package: methods
This is forecast 7.1

Error in if (frequency > 1 && abs(frequency - round(frequency)) < ts.eps) frequency <- round(frequency) :
missing value where TRUE/FALSE needed
Calls: ts
Execution halted


Stack Trace
Microsoft.PowerBI.ExploreServiceCommon.ScriptHandlerException: Erro de script do R.
Loading required package: scales
Loading required package: forecast
Loading required package: zoo

Attaching package: 'zoo'

The following objects are masked from 'package:base':

as.Date, as.Date.numeric

Loading required package: timeDate
Loading required package: methods
This is forecast 7.1

Error in if (frequency > 1 && abs(frequency - round(frequency)) < ts.eps) frequency <- round(frequency) :
missing value where TRUE/FALSE needed
Calls: ts
Execution halted
---> Microsoft.PowerBI.Radio.RScriptRuntimeException: Erro de script do R.
Loading required package: scales
Loading required package: forecast
Loading required package: zoo

Attaching package: 'zoo'

The following objects are masked from 'package:base':

as.Date, as.Date.numeric

Loading required package: timeDate
Loading required package: methods
This is forecast 7.1

Error in if (frequency > 1 && abs(frequency - round(frequency)) < ts.eps) frequency <- round(frequency) :
missing value where TRUE/FALSE needed
Calls: ts
Execution halted

em Microsoft.PowerBI.Radio.RScriptWrapper.RunScript(String originalScript, Int32 timeoutMs)
em Microsoft.PowerBI.Client.Windows.R.RScriptHandler.GenerateVisual(String script, String inputVariableName, IDataReader dataReader, Nullable`1 viewportWidthPx, Nullable`1 viewportHeightPx)
--- Fim do rastreio da pilha de excepção interna ---
em Microsoft.PowerBI.Client.Windows.R.RScriptHandler.GenerateVisual(String script, String inputVariableName, IDataReader dataReader, Nullable`1 viewportWidthPx, Nullable`1 viewportHeightPx)
em Microsoft.PowerBI.ExploreServiceCommon.ScriptVisualCommandFlow.RunInternal(Stream dataShapeResultStream, QueryBindingDescriptor& bindingDescriptor)
em Microsoft.PowerBI.ExploreServiceCommon.ScriptVisualCommandFlow.Run(Stream dataShapeResultStream, QueryBindingDescriptor& bindingDescriptor)
em Microsoft.PowerBI.ExploreHost.SemanticQuery.ExecuteSemanticQueryFlow.TransformDataShapeResult(QueryCommand transformCommand, String dataShapeId, SemanticQueryDataShapeCommand command, Stream dataShapeResultStream, QueryBindingDescriptor& bindingDescriptor)
em Microsoft.PowerBI.ExploreHost.SemanticQuery.ExecuteSemanticQueryFlow.ProcessAndWriteDataQuery(IQueryResultDataWriter queryResultDataWriter, DataShapeGenerationContext dsqGenContext, EntityDataModel model, DataQuery query, ServiceErrorStatusCode& serviceErrorStatusCode)
em Microsoft.PowerBI.ExploreHost.SemanticQuery.ExecuteSemanticQueryFlow.ProcessAndWriteSemanticQueryCommands(IQueryResultsWriter queryResultsWriter, ExecuteSemanticQueryRequest request, IConceptualSchema conceptualSchema, EntityDataModel model)

 

 

If only one time series selected, visual does appear, but prediction model transforms into an useless predictive model.

 

Keep it up with the good work.

Anonymous's avatar
Anonymous
Not applicable
10 years ago

To those who have issues with "Error in if (frequency > 1 && abs(frequency - round(frequency)) < ts.eps) frequency <- round(frequency) :" it turns out R uses your local language setting to determine a month name... 

If you add the following to you R-script it should force the code to use english setting:

Sys.setlocale("LC_ALL","English")

Make sure to add it the to top of the code

 

Hope this helps you too :

  • hohlick's avatar
    hohlick
    Continued Contributor
    10 years ago

    Thank you Anonymous, it works now!

  • HMonteiro's avatar
    HMonteiro
    New Member
    10 years ago

    Solved! Many thanks!

    • JuliaYebra's avatar
      JuliaYebra
      Helper III
      10 years ago

      Anonymous excellent!!!! Thank you!!!

      • shreekishore's avatar
        shreekishore
        Frequent Visitor
        9 years ago

        Could you send any one the source file births.csv file.

         

        Thanks,

    • shreekishore's avatar
      shreekishore
      Frequent Visitor
      9 years ago

      please send Births.csv file 

      • Jacob_Minsky's avatar
        Jacob_Minsky
        Microsoft Employee
        9 years ago

        I am attaching the births.xlsx file used to create this visual.

        births.xlsx65 KB
  • © 2026 Microsoft
  • Manage cookies
  • Privacy & cookies
  • Terms of use
  • Trademarks
Your Privacy Choices Consumer Health Privacy