Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I am trying to follow the example in Microsoft website
I have installed R 3.5.1 and latest RStudio.
I have installed the "mice" package.
I have loaded the file EuStockMarkets_NA and from within Power Query inserted the "Run R Script" step.
I have copied and pasted the code in the example and while running it, got an error message, :
DataSource.Error: ADO.NET: R script error.
Loading required package: lattice
Attaching package: 'mice'
The following objects are masked from 'package:base':
cbind, rbind
Error in parse(text = x, keep.source = FALSE) :.........
Please find the file in this link: Running R script error
Thank you for the help,
Regards,
Tamir
Solved! Go to Solution.
I found the problem...
The script in the Microsoft Demo should have an extra line to set the dataset parameter
dataset <- read.csv(file="C:/Users/user/Google Drive/PowerPivot Power BI/EuStockMarkets_NA.csv", header=TRUE, sep=",")
Tamir
I found the problem...
The script in the Microsoft Demo should have an extra line to set the dataset parameter
dataset <- read.csv(file="C:/Users/user/Google Drive/PowerPivot Power BI/EuStockMarkets_NA.csv", header=TRUE, sep=",")
Tamir
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |