Forum Discussion
How to read / import a SAS dataset from a remote Unix Server into Power BI
Hello,
Up to now, I have been able to read / import a SAS Dataset from a window Server using the following script into Power BI.
library(sas7bdat)
require(sas7bdat)
Class2 <-read.sas7bdat("P:/Folder_1684/class.sas7bdat")
But when comes the time to do the same thing from a Unix Server, it does not work.
I believe I need to first connect to our Unix Server by providing the IP address/name, username, password and probably the port number.
But in R, I don't know how to do that.
Does someone could provide me an example of a scritp that is working.
Regards,
2 Replies
v-yanjiang-msftCommunity Support
Hi Anonymous ,
Here are some posts introducing how to import SAS data into Power BI using R script. Reference:
Importing SAS data into PowerBI;
Reading SAS (*.sas7bdat) Files In Power BI;
Reading SAS files from Power BI using R Script.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please considerAccept it as the solution to help the other members find it more quickly.
Hello,
I have looked at all the 3 links provided and I have read the documentation. All the examples provided show how to read a sas dataset hosted on the c drive of a pc. I need to find how to read/import a SAS dataset in Power BI which is hosted on a Unix server. I believe that we will need to first connect to that server using R (which package to use ?), by providing either the server name and/or its IP address, the username, password and maybe the port number. When we will connected to that server, I believe that it will be possible to read / import a SAS dataset.
I need help from the community or a microsoft expert.
Regards,