Forum Discussion

Markzolotoy's avatar
Markzolotoy
Impactful Individual
9 years ago
Solved

Connecting to remote sql server

I am trying to get data from a remote server. Because the box I am connecting from is not a domain box Windows Authentication is not working. Hocan I switch to the server authentication?   Thanks
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Markzolotoy,

    You can connect to SQL Server in Power BI Desktop using SQL authentication credentials. Choose Database option in the following screenshot, then enter your username and password to connect to SQL Server.


    Thanks,
    Lydia Zhang

parry2k's avatar
parry2k
Super User
9 years ago

I belive you can use alternate credentials to connect

 

dosc's avatar
dosc
Frequent Visitor
3 years ago

Posting this here for people struggling with alternate credentials when connecting to remote SQL Server via VPN from a machine outside of the domain.

You can use the runas /netonly command (this does not work with the Power BI Desktop installation from Microsoft Store). Start Power BI Desktop via cmd with the following command:
runas /netonly /user:[domain]\[user] [path\to\PBIDesktop.exe]

Provide the password and then use current credentials in windows authentication when connecting Power BI Desktop to the SQL Server. You can find a step by step guide here