Forum Discussion

rohuyn's avatar
rohuyn
Frequent Visitor
9 years ago
Solved

ADO.NET: Rscript error - Cannot find Dataset

Hi everyone,   I'm in the process of finalizing my Forecasting Dashboard, but am having trouble actually explicitly showing my forecasting values in a non-plot. I surmised that the best way to go a...
  • ankitpatira's avatar
    ankitpatira
    9 years ago

    rohuyn I think all you need to do is explicitly specify path of FinalDataR.xlsx instead of just the name as by default it will try to look into R directory but cannot find the file. So specify like C:/MyData/FinalDataR.xlsx and it should work.

ankitpatira's avatar
ankitpatira
Community Champion
9 years ago

rohuyn I think all you need to do is explicitly specify path of FinalDataR.xlsx instead of just the name as by default it will try to look into R directory but cannot find the file. So specify like C:/MyData/FinalDataR.xlsx and it should work.

rohuyn's avatar
rohuyn
Frequent Visitor
9 years ago

Perfect! Thanks, ankitpatira!

 

Just to clarify, this script now works due to ankitpatira's advice:

library(readxl)
library(forecast)

FinalData <- read_excel("C:\\Users\\rohuyn\\Desktop\\Team\\Team Projects\\Price Elasticity\\FinalDataR.xlsx", sheet = "Final Raw Data")

ForecastData <- aggregate(Revenue~Month, data = FinalData, FUN = sum)

GeneralForecast <- ts(ForecastData$Revenue, start = 0, freq = 12)

fit <- arima((GeneralForecast), c(1, 1, 0),seasonal = list(order = c(1, 1, 0), period = 12))

ActualForecast <- forecast.Arima(fit, h = 5)
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I am trying to export data from power bi to csv file using R

    I am giving the below command

    write.csv(ALL_Data, "C:\\Users\\username\\Documents\\folder 1\\folder 2\\folder 3\\folder 4\\filename.csv")

    I am getting the below error please help

    DataSource.Error: ADO.NET: R script error.
    Error in is.data.frame(x) : object 'ALL_Data' not found
    Calls: write.csv ... eval.parent -> eval -> eval -> write.table -> is.data.frame
    Execution halted

    Details:
        DataSourceKind=R
        DataSourcePath=R
        Message=R script error.
    Error in is.data.frame(x) : object 'ALL_Data' not found
    Calls: write.csv ... eval.parent -> eval -> eval -> write.table -> is.data.frame