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,

 

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

  • Ghislain's avatar
    Ghislain
    Advocate I
    9 years ago

    v-ljerr-msft Thanlks for your answer ! But where I can find the port ?

    • 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 !!! 

  • Karthik12's avatar
    Karthik12
    Post Patron
    4 years ago

    Hi, Woww.. I am also searing for the same. Is it applicable for MySQL too? Our production date tables stored in MySQL server and comes like .php.