Can't connect to datamart using SQL string on Power BI desktop

[matheus14m]

Hello everyone,

My team and I are currently facing a challenging issue, and I'm not sure what else to try to solve it. We're encountering difficulties while attempting to connect on Power BI desktop to all the datamarts we create using the SQL connection string.

Specifically, when we try to connect using the SQL Server connector, we consistently encounter the same error as shown in the image below:

Strangely, the error only occurs on our organization's computers. When attempting to connect to the same datamarts using our personal computers, everything works perfectly fine.

Does anyone have any insights on whether there are specific connection settings that need to be configured on our organization's computers? Any information on this matter would be greatly appreciated, as it would help us guide our IT team in resolving this issue effectively. Thank you for your time and assistance.

[v-xinruzhu-msft]

Hi @matheus14m 

Please check the following points:

If you enable necessary protocols (TCP/Named Pipes) in SQL Server Configuration Manager.

Did you select the organizational account when authenticating, you can refer to the folliwng link.

https://learn.microsoft.com/en-us/power-bi/transform-model/datamarts/datamarts-create-reports#create...

And you can refer to the following link.

“… an error occurred during the pre-login handshake.” & “[DBNETLIB][ConnectionOpen (SECDoClientHands...

[1/26 2:03 PM] Xinru Zhu (Shanghai Wicresoft Co,.Ltd.)

Best Regards!

Yolo Zhu

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