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 the Ip adress in the server name ? or IPADRESS:ServerName ? If not where I have to mention th ip adress ?

 

 

Thanks in advance,

Ghislain

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

5 Replies

  • 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

      • 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

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