I would like to see SAS datasets available for import into PowerBI. We would use this every day if it were availabe.
I would like to see SAS datasets available for import into PowerBI. We would use this every day if it were available.
Alexandre Perreault commented
As SAS is used more and more at my office, having the possibility to use a direct connect functionality to SAS would greatly help in the data democratization. This is a cultural change happening at my employer.
Graham McDonald commented
Please enable Power BI to read SAS data sets (.SAS7BDAT)
In PowerBI desktop with Microsoft R Client, you can import SAS tables using R script as a data source:
# Importing SAS Data
inFileSAS <- file.path(rxGetOption("sampleDataDir"), "claims.sas7bdat")
xdfFileSAS <- "claimsSAS.xdf"
claimsSAS <- rxImport(inData = inFileSAS, outFile = xdfFileSAS)