none
Connecting to SQL Server with Power Query-Received Certificate has expired RRS feed

  • Question

  • Hi ,

    I am trying to connect to SQL server with Power query.

    I am using the authentication mode as Windows..

    When i try to connect to SQL server, I am getting the below error

    "A connection was successfully established with the server, but then an error occurred during the login process. (provider:SSL Provider, error 0-The received certificate has expired.)



    • Edited by DagdooE Friday, November 6, 2015 12:58 AM
    Friday, November 6, 2015 12:58 AM

Answers

  • Hi there DagdooE,

    Had the same thing with Power BI Desktop.  To get working I went to 'Data Source Settings' then unchecked the 'encrypt connections' check box (for the data source). 

    All the best


    • Edited by BI_ker Friday, November 6, 2015 1:26 AM
    • Marked as answer by DagdooE Friday, November 6, 2015 2:57 AM
    Friday, November 6, 2015 1:25 AM

All replies

  • Hi there DagdooE,

    Had the same thing with Power BI Desktop.  To get working I went to 'Data Source Settings' then unchecked the 'encrypt connections' check box (for the data source). 

    All the best


    • Edited by BI_ker Friday, November 6, 2015 1:26 AM
    • Marked as answer by DagdooE Friday, November 6, 2015 2:57 AM
    Friday, November 6, 2015 1:25 AM
  • Hi BI_ker,

    how can you change the setting when it is not allwoing us to create one.

    have you done this for sql server ?

    Please let us now more about this.

    Regards,

    Rahul Sharma


    lntinfotech

    Saturday, February 25, 2017 7:59 AM
  • I'm getting the same error with an Excel file, but only when other people try to refresh the connection. I can refresh it without the error. 

    I was also getting the error in PowerBI and resolved it the same way as pointed out below.

    While Power BI has the "encrypt connections" check box, Excel's connection doesn't. I do believe the issue has something to do with encryption but I can't find anything in the Excel Power Query connection properties that relate. 

    Anyone have any thoughts?

    Monday, May 8, 2017 5:11 PM
  • thank's man, it works
    • Edited by Datain Monday, March 5, 2018 9:30 AM
    Monday, March 5, 2018 9:30 AM
  • Hi,

    Where is this setting in Power BI? Can you please share?

    Thanks

    Mayank

    Monday, June 18, 2018 12:57 PM
  • On the Ribbon, click on "Home" group; then click "Edit Queries"; then you see the option. 
    Wednesday, August 22, 2018 3:44 PM
  • It Worked. Thanks
    Wednesday, January 9, 2019 11:32 AM
  • Hello!

    I am echoing what someone already said above : "how can you change the setting when it is not allwoing us to create one." 

    What you guys are suggesting works for already existing data sources in Power BI. I am trying to connect to SQL Server as a new data source.  It won't let me create the new data source with that error. For the existing data sources, I can go and change the existing connections to what you guys have been saying but for the new data source, it won't let me connect at all. How do I overcome that?

    Tuesday, February 26, 2019 7:36 PM
  • Did you solve this in any way?
    I'm also not able to create the connection in the first place.


    If this answers your question please mark it accordingly
    Nicky van Vroenhoven - MCSA SQL Server


    Wednesday, June 5, 2019 9:34 AM