Loading sas7bdat Files into Power BI
Power BI has a lot of data sources. Unfortunately, it does not have a built-in connector for SAS
*.sas7bdat files. The good news is that Power BI fully supports working with R data sources, and it is very simple to create a script to read in R files.
First, let’s make sure you’ve installed the sas7bdat package into your local R installation.
Now, all you need is a two line script to read in a SAS data set.
library(sas7bdat) df <- read.sas7bdat("//path/to/data/source.sas7bdat")