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

[Ghislain]

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

[v-ljerr-msft · Accepted solution]

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.

Regards

[Karthik12]

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. 

[Ghislain]

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

[v-ljerr-msft]

Hi @Ghislain,

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

Regards

[Ghislain]

Thx I find it in Sql Server Config !!!