Power Query error in connecting to data source using an encrypted connection

Question

I am trying to connect to a db running on (localdb)\v11.0 using power query, but I always got the following error:

DataSource.Error: Microsoft SQL: The instance of SQL Server you attempted to connect to does not support encryption.
Details:
Message=The instance of SQL Server you attempted to connect to does not support encryption.
Number=20
Class=20

Answer 1

In the Query Editor go to File->Options and Settings -> Data Source Settings. Choose your (localdb)\v11.0 and select Edit and turn off "Encrypt Connections". Once it is off you should be able to Refresh from the Home tab.