Forum Discussion

PremK's avatar
PremK
Resolver I
1 year ago

Unable to connect SQL Server with PBI

I had connected this SQL Server with SSMS and its connected well and able to interact with the data bases and tables in it.

But while i tried to connect the same SQL Server with Power BI to create reports its showing error like 

 

 

provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.

I had tried with these Certificate Revocation options in PBI Desktop Settings, but it doesn't help me out 

 

Also done these two steps, but nothing helps - 
1. Adding / Editing Environment Variable  - the variable name should be Name of the SQL Server.
2. Updating PBI Desktop Config file in this path
C:\Users\<YourUsername>\AppData\Local\Microsoft\Power BI Desktop\User.zip
updating this - <setting name="SqlTrustedServers" serializeAs="String"> <value>NAMES OF YOUR SQL SERVERS </value> </setting>

 


kindly provide me solution to Connect SQL Server and PBI...

Need Help

3 Replies

  • dharmendars007's avatar
    dharmendars007
    Memorable Member
    1 year ago

    Hello PremK ,

     

    You can connect try the below step also you can in the global permission setting re-connect the data source you are trying to connect.

     

    Update Power BI Settings:

    • Go to the "Data Source Settings" in Power BI.
    • Select your SQL Server connection and click on "Edit Permissions."
    • Ensure that "Encrypt Connection" is checked if SSL is required. If your server doesn’t require SSL, you may uncheck this option, but this may compromise security.

    If you find this helpful , please mark it as solution and Your Kudos are much appreciated!

     

    Thank You

    Dharmendar S

    LinkedIN 

    • PremK's avatar
      PremK
      Resolver I
      1 year ago

      The Encrypt Connection was already unchecked, and this doesn't solved this issue.

       

      kindly give any other solutiones pls

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi dharmendars007 ,thanks for the quick reply, I'll add more.

    Hi PremK ,

    Regarding your issue, please make sure that the certificate used by SQL Server is in the Trusted Root Certification Authority store of the computer running Power BI Desktop. For more information, please refer to the following article, I hope it will help you.

    SSL Security Error with Data Source | Microsoft Power BI Blog | Microsoft Power BI

     

    Best Regards,
    Wenbin Zhou