Hello, can you please advise how I can set up an encrypted connection from PBI Desktop to SQL Server?
Currently I am getting the following error message.
"The data source you're trying to access doesn't support encryption. To access this data source using an unencrypted connection, click OK."
I have looked through the following threads but could not find the right advice.
Power BI version: 2.62.5222.761 64-bit (September 2018)
Storage Mode: Direct Query
SQL Server version: Microsoft SQL Server Developer (64-bit) 13.0.1601.5
I followed this guide to configure database encryption: https://www.sqlshack.com/how-to-configure-transparent-data-encryption-tde-in-sql-server/
Do I need to also follow this guide to configure encrypted connections? https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/enable-encrypted-connections-...