Forum Discussion
What secure protocol does Power BI use for Azure SQL Server?
Hi, Our security group had a question about what secure protocol does Power BI Desktop use when you go from on premise to a Azure SQL Server using the Azure SQL Server connector? Thanks!
By default it will use TLS 1.2 - see https://docs.microsoft.com/en-us/azure/sql-database/sql-database-security-overview#information-protection-and-encryption
According to the documentation "Sql Server enforces encryption (TLS) at all times for all connections. This ensures all data is encrypted "in transit" between the client and server irrespective of the setting of Encrypt or TrustServerCertificate in the connection string."
Does that mean, all the traffic is encrypted even if I disable "Enrypt connection" in the Data source settings in PBI Desktop?
Thx in advance