Forum Discussion

Ghislain's avatar
Ghislain
Advocate I
9 years ago
Solved

How to get data from SQL Server from an external server ?

Hi Power Bi community !   I'm dealing with a problem today but i don't have any issue. Indeed I want to know how to get data from SQL Server from an external server in Power Bi Desktop. Do I enter ...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi Ghislain,

     

    I just verified that I can connect successfully to one of my remote SQL Server by IP address with my Power BI Desktop. I'm using (IP,Port) for the Server field in Power BI Desktop.:smileyhappy:

     

    sqlip1.PNG

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi Ghislain,

 

Here a good article about how to identify SQL Server TCP IP port being used for your reference.:smileyhappy:

 

Regards

Ghislain's avatar
Ghislain
Advocate I
9 years ago

Thx I find it in Sql Server Config !!!