Getting error while connecting SQL As data source , not sure what is the mapping values wrt sql serv

[dhrub]

Hi Friends, 

I am getting error while connecting to SQL data source using both import or direct query , I want to rule out whether I am using right input values or some other permission issue as I can directly connect from SQL server with same credentials 

Steps tried : 
I have used hostname: port from SQL server connection as value for Server field in power bi 
I have also used only hostname as value for Server field in power bi

Can you guys share your exp if you are kind . .so that I can reach out to right team or rectify if I am not doing it the right way

SQL server con screenshot

Power bi screenshot after clicking Get data -> SQL Server

Error I am getting below error message : for all scenario

[Anonymous]

Hi @dhrub ,

Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your problem.

Best Regards,
Stephen Tao

[fhill]

If one of these post helped resolve your issues, please mark it as a solution, and/or let us know the actual solution?  Thank You,

Forrest

[Anonymous]

Hi @dhrub ,

I found this simliar post about TCP Provider, error: 0. Please kindly refer to:

Failed to connect to SQL Server

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PhilipTreacy]

Hi @dhrub 

What version of PBI Desktop are you using?  Make sure you are up to date with the latest version.  There's a known issue connectng to SQL Server with certain PBID versions

https://community.powerbi.com/t5/Desktop/Reports-stopped-refreshing-Pre-login-Handshake-Error/m-p/13...

Regards

Phil

[fhill]

Can you Telnet Connect successfully from the machine running Power BI to the SQL Server?  See Check #3 on this link...

https://www.mssqltips.com/sqlservertip/4828/verify-connectivity-to-sql-server/

[amitchandak]

@dhrub , Have you used the Database option on next screen if you do want to use windows authentication?

On the above one you are showing Oracle connection details. But in power Bi you trying for SQL server ?

https://community.powerbi.com/t5/Desktop/Using-SQL-Authentication/td-p/3151

https://www.sqlshack.com/using-power-bi-desktop-connect-sql-server-facebook/