Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
matheus14m
Frequent Visitor

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

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:

matheus14m_0-1690294934512.png

 

matheus14m_1-1690294949799.png

 

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.

1 REPLY 1
v-xinruzhu-msft
Community Support
Community Support

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.

 

 

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!