Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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?
I guess more of what I'm looking for is how to require encryption from a custom sql connector
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