Forum Discussion

SHill83's avatar
SHill83
Frequent Visitor
1 year ago
Solved

Error message when refreshing the data in power bi desktop

Hello,   i need help with refreshing the data in power bi, i am suddenly getting this message:   Microsoft SQL: A connection was successfully established with the server, but then an error occurr...
  • SHill83's avatar
    SHill83
    1 year ago

    Jai-Rathinavel  & Anonymous thank you so much for your suggestions - i have now sorted the issue. For some reason it wasn't allowing the standard database connection i was previously using, so i set up a new SQL user that i could use for the database connection and it worked! Thanks so much for your help!

Jai-Rathinavel's avatar
Jai-Rathinavel
Icon for Super User rankSuper User
1 year ago

Hi SHill83,

 

"A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.) (.Net SqlClient Data Provider)"

 

The exact error has been documented under Microsoft's Learn page. Please go through the below link and see if that helps.

 

https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/connect/error-message-when-you-connect  

 

Thanks,

Jai