Power BI - Enterprise Gateway to SQL Server 2016 & SQL Server 2016 "AlwaysEncrypted"

[dpetrancuri_LIP]

Does PowerBI support the use of SQL Server 2016 AlwaysEncrypted?

I suspect it does not at present, but I would like to believe there is thought being given to how to implement such in the future.

That being said, I understand that the rationalization of use of AlwaysEncrypted in a data warehouse environment is somewhat difficult from a performance perspective. Furthermore, one could reasonably contend that there is no need for sufficiently detailed personally identifying information (PII) in a data warehouse that would allow someone to identify an actual real world 'person' from the information contained within a data warehouse.

[ankitpatira · Accepted solution]

@dpetrancuri_LIP No it doesn't. It actually warns you first time you're connecting saying encryption is not supported.