Hi
so, yes, you can. Its a little bit of a process to set up. however it seems to work well.
1. Download and install R - the later the version the better. I have 3.4.3.
2. download and install the sas7bdat library for R.
This can be done through R, by using the command install.packages("sas7bdat")
This will download the files to some downloads folder. R will tell you where.
I am no R wizard, so the easiest, I have found, is to then browse to the location. Under the data folder, there is a file 'sas7bdat.sources.RData'. Drag and drop this file into R, and it will install it.
You can close R at this point.
3. Open PoweBI. Under settings, check that it picked up your R installation.
if not, you will need to point it to the right folder.
4. click 'get data' and choose the 'R script' option under other.
5. the script you'll us is:
library(sas7bdat)
require(sas7bdat)
input<-read.sas7bdat("Z:/folder/folder/my_SAS_file.sas7bdat")
remember that R, like Linux, uses '/' in its file paths, not '\' as in Windows.
6. This script will pull in your data and you'll be able to refresh it as normal.
Good Luck!
GD
... View more
