Forum Discussion

DannyX's avatar
DannyX
Frequent Visitor
7 years ago
Solved

Connect to remote server via VPN

Hi all, Ii struggle with the following topic: How can i connect PowerBI Desktop to a remote server via VPN ? I build up some reports and dashboards for my client in PowerBI Desktop and published t...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi DannyX 

    First make sure your local server communicates with remote server properly.

     

    1.

    For CSV- and Excel Files on a remote server, like a VM

    In Power BI, Get Data-Excel/Csv, Enter path like

    \\VM897909\test\yh.xlsx            \\(VM name)\(folder path)\(file name)

     

    Then select correct authentication.:

    It may pop out with "Window authetication",

    you could check which authentication type works for your scenario:

    "current windows authetication" or "alternative windows authetication"(use credential for VM)

     

    2.

    When connect to a database in a remote server,

    Choose Database authentication option, then enter your username and password to connect to the database.

    or use alternate Windows credentials to connect.

    There is a similar thread you could refer to:

    https://community.powerbi.com/t5/Desktop/Connecting-to-remote-sql-server/td-p/118831

     

     

    Best Regards
    Maggie

     

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

     

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi DannyX 

First make sure your local server communicates with remote server properly.

 

1.

For CSV- and Excel Files on a remote server, like a VM

In Power BI, Get Data-Excel/Csv, Enter path like

\\VM897909\test\yh.xlsx            \\(VM name)\(folder path)\(file name)

 

Then select correct authentication.:

It may pop out with "Window authetication",

you could check which authentication type works for your scenario:

"current windows authetication" or "alternative windows authetication"(use credential for VM)

 

2.

When connect to a database in a remote server,

Choose Database authentication option, then enter your username and password to connect to the database.

or use alternate Windows credentials to connect.

There is a similar thread you could refer to:

https://community.powerbi.com/t5/Desktop/Connecting-to-remote-sql-server/td-p/118831

 

 

Best Regards
Maggie

 

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

 

DannyX's avatar
DannyX
Frequent Visitor
7 years ago

Hi Maggie,

 

thank you very much for your support !! It starts working :smileyhappy: I could connet to the remote sever and get the CSV-Files. For connecting with the databases i still struggle a little bit with authentication errors but I'm on the right way. 

 

Best regards

Danny

  • rammy's avatar
    rammy
    Helper I
    4 years ago

    Hi

    which one is support 1 or 2  
    i am strugguling with this only