Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Power BI Report Server and Always Encrypted

Hi,

 

Reading https://docs.microsoft.com/en-us/power-bi/report-server/always-encrypted-support I am still unsure where I need to put in the "Column Encryption Setting=enabled" in the connedtion string. At the bottom of this page where the connection sring is detailed a link is given which, when viewed, doesn't detail how to set the connection in relation to Power BI.

 

Going through the data source set-up connection for a Power BI report to a SQL Server 2016 I don't see anywhere I can put this connection string command. Am I missing something? I feel I may need to put this in manually in the 'source' comand in the Advanced Editor of the Power Query Editor but any attempt I try always results in a Expression Error. 

 

Can anyone please guide me to how to go about setting up the encrypted connection?

 

Thanks

 

No Replies