Power BI
Needs VotesI would like to see SAS datasets available for import into PowerBI. We would use this every day if it were availabe.
Jeremiah Robinson on 20 Sep 2016 21:17:19
I would like to see SAS datasets available for import into PowerBI. We would use this every day if it were available.
- Comments (3)
RE: I would like to see SAS datasets available for import into PowerBI. We would use this every day if it were availabe.
Good afternoon,
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.
Thank you.
RE: I would like to see SAS datasets available for import into PowerBI. We would use this every day if it were availabe.
Please enable Power BI to read SAS data sets (.SAS7BDAT)
RE: I would like to see SAS datasets available for import into PowerBI. We would use this every day if it were availabe.
Hi,
In PowerBI desktop with Microsoft R Client, you can import SAS tables using R script as a data source:
https://msdn.microsoft.com/en-us/microsoft-r/scaler-user-guide-data-import#importing-fixed-format-data
# Importing SAS Data
inFileSAS <- file.path(rxGetOption("sampleDataDir"), "claims.sas7bdat")
xdfFileSAS <- "claimsSAS.xdf"
claimsSAS <- rxImport(inData = inFileSAS, outFile = xdfFileSAS)