Forum Discussion

Ghislain's avatar
Ghislain
Icon for Advocate I rankAdvocate 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
Icon for Microsoft Employee rankMicrosoft 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

Karthik12's avatar
Karthik12
Icon for Post Patron rankPost 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.