5

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

TylerH
  • 20,799
  • 66
  • 75
  • 101
carlos
  • 815
  • 2
  • 14
  • 27
  • 1
    Please enable tracing in Power Query and then reproduce the error. Once done, use the "send a frown" feature to report the problem and attach your traces. Tracing can be enabled from the Options dialog on the Power Query ribbon. – Curt Hagenlocher Feb 08 '15 at 09:04

2 Answers2

4

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.

TylerH
  • 20,799
  • 66
  • 75
  • 101
Macgyver
  • 41
  • 3
0

In older versions of Power Query, manually turning off encryption would be the only way to resolve this.

If you get this message in newer versions (2.27 or later), if you get this error you'll be directly prompted to turn off encryption. If that doesn't seem to be working, Send-A-Frown to get in touch with our support teams.

Carl Walsh
  • 6,100
  • 2
  • 46
  • 50