DataSource.Error: Microsoft SQL - Power BI

Gaston N Escobar 0 Reputation points
2024-07-04T14:38:30.8166667+00:00

Good day, I have a problem with Power BI, when I try to import a database it generates the following error: DataSource.Error: Microsoft SQL: 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.).

 

This happens to me only with the new versions, with the November version I don't have that problem.

 

Would someone help me solve it?

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,217 questions

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 105.8K Reputation points MVP
    2024-07-04T15:51:33.63+00:00

    You have three options:

    1. Specify that encryption is optional. (Modern drivers defaults to required it.)
    2. Select the option Trust Server Certificate.
    3. Install a proper certificate from a trusted certificate provider on the SQL Server instance.

    The latter is likely to be more work, and may also incur extra costs. However, you need to weigh that against the alternatives. With no encryption, anyone can eavesdrop on the communication. With the second alternative, someone can still get in the way and present itself as the SQL Server instance with a certificate. This is a so-called man-in-the-middle attack. The more sensitive your data is, the more compelling it is to use proper encryption.

    For details on how to set these options with PowerBI, it may be better to use the PowerBI forum at https://video2.skills-academy.com/power-bi/.

  2. ZoeHui-MSFT 34,836 Reputation points
    2024-07-05T02:36:37.3533333+00:00

    Hi @Gaston N Escobar,

    This error occurs when you try to make an encrypted connection to SQL Server using a non-verifiable certificate.

    If you intentionally use either a certificate from a non-trusted authority or a self-signed certificate to encrypt connections to SQL Server, you can use one of the following options mentioned in the article.

    "The certificate received from the remote server was issued by an untrusted certificate authority" error when you connect to SQL Server

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments
  3. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  4. Olaf Helper 42,841 Reputation points
    2024-07-05T05:18:53.1833333+00:00

    SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.).

    Add "Encrypt=False" to the connection string to surpress connection encryption by SSL, see

    https://www.connectionstrings.com/all-sql-server-connection-string-keywords/

    0 comments