PowerBI Direct Query Connection Security

[wilhelmF]

Hi, 

when I connect to my tabular models on SQL Server 2016 from PowerBI Desktop, what kind of connection is used? Is the data transferred encrypted? Which method is used? I got a question from security.

Thanks

[v-sihou-msft]

@wilhelmF

The connection is made of security context. Your current Windows credentials are used to connect to the Analysis Services server. It just connects like other client applications. There's no encryption on data transfer since you are connecting directly within same domain. For more details about SSAS connection, please see: Connection String Properties (Analysis Services)

Regards,

[wilhelmF]

@v-sihou-msft thank you very much for your reply. I guess the Security Officers next question will be, is the connection then unsafe? Because when connecting to SQL Server Database one has the option to choose encrypted connection isn't there something similar for SSAS?

[wilhelmF]

Hi, 

when I connect to my tabular models on SQL Server 2016 from PowerBI Desktop, what kind of connection is used? Is the data transferred encrypted? Which method is used? I got a question from security.

Thanks