Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

How to read / import a SAS dataset from a remote server using Microsoft R Open and then use it in PB

Hello,

 

I would like to know how to connect to a remote Server using R then read/import a SAS dataset in Power BI.

Up to now I was able to read a sas dataset hosted on my pc but not on our unix server.

 

How to do that ?

2 Replies

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Icon for Community Support rankCommunity Support

    Hi Anonymous ,
    1.Ensure that you have access to the CONNECT remote desktop service
    2.Submit a request to have Power BI desktop added to your apps and wait for this to be fulfilled. We suggest the following details:
    Please grant me access to the PowerBI desktop app in the CONNECT remote desktop service (add to AD Group RAPP-RA-Power BI Desktop)
    3.Login to the CONNECT remote desktop service, select Power BI Desktop from your desktop icons to download the installer package. Save and open / run the downloaded file, confirming any prompts
    4.When asked to sign in, enter your username in the format CONNECT\abcd1234 and your CONNECT password.

    https://help.it.ox.ac.uk/power-bi-connecting-to-power-bi-desktop-via-remote-desktop-connection

    https://community.powerbi.com/t5/Developer/Connecting-Power-BI-to-a-remotely-hosted-SQL-Server-Database/m-p/1797026


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hello

      The information about how to connect to a SQL server is interesting but I need the information about how to connect to a Unix Server