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
