How to read / import a SAS dataset from a remote Unix Server into Power BI

[ALePage]

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,

[ALePage]

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,

[v-yanjiang-msft]

Hi @ALePage ,

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 _ kalyj

If this post helps, then please considerAccept it as the solution to help the other members find it more quickly.