Share via

Encrypt a SQL session with PowerBI Desktop

Erik Verheuvel 41 Reputation points
2024-05-14T09:38:46.7366667+00:00

I want to connect to a local SQL Server database, using Power BI Desktop. On the SQL Server instance encryption has been enforced.

When I make the connection Power BI Desktop keeps telling that it cannot make a connection because encryption is not available on the SQL Server. Encryption works fine when I make a connection with SSMS.

Is it somehow possible to let PowerBI desktop use Encrypt=True;TrustServerCertificate=True, on a connection to a SQL Server instance?

Do I need to change some settings on the SQL Server Instance to make it work?

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

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 33,941 Reputation points
    2024-05-15T03:16:05.0766667+00:00

    Hi @Erik Verheuvel,

    When I look at the session, on the SQL Server instance, it shows that the session is not encrypted. That is not exactly what I need.

    If you mean that you want to encrypt connections for SQL Server, you may check the official documentations.

    Configure SQL Server Database Engine for encrypting connections

    Special cases for encrypting connections to SQL Server

    For PBI connect issue, you may also raise the question to PBI community.

    Regards，

    Zoe Hui

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

    0 comments