Encryption in a custom connector

[jjudy]

My IT dept requires in-transit encryption. I have a data source that, when using the generic SQL Server connector, will not connect with encryption. I built a custom connector with SupportsEncryption = true based on the Direct Query for SQL Server sample. I can connect to the data source now with the Encrypt Connections box checked and the connection works. 

Does the simple switch of SupportsEncryption = true actually enable encryption or is there more that needs to be included?

[jjudy]

I guess more of what I'm looking for is how to require encryption from a custom sql connector

[v-jayw-msft]

Hi @jjudy ,

You could refer this blog about Power BI and SQL Always Encrypted.

https://www.linkedin.com/pulse/power-bi-sql-always-encrypted-felipe-andrade .

Best Regards,

Jay