Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Description
Prerequisites (The sample .pbix files will not work without these prerequites completed)
1. Install R Engine
Power BI Desktop does not include, deploy or install the R engine. To run R scripts in Power BI Desktop, you must separately installR on your local computer. You can download and install R for free from many locations, including the Revolution Open download page, and the CRAN Repository.
2. Install the required R packages.
Download the R script attached to this message and run it to install all required packages on your local machine.
Required R packages:
forecast, graphics, scales, zoo
Tested on:
CRAN 3.3.1, MRO 3.3.0, powerbi.com
Legal Disclaimers:
Terms of Service and Third Party Programs.
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 :
Solved! Many thanks!
please send Births.csv file
@Anonymous excellent!!!! Thank you!!!
Could you send any one the source file births.csv file.
Thanks,
Could you send any one the source file births.csv file.
Thanks,
Do not sure why, but visual don't work:
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) :
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 :
/Chris