Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Manuka
Frequent Visitor

SQL Database connection issues with current PBI Version

Hello together,

 

me and my colleague facing on different machines with the newest PBI Desktop version this issue.

 

Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the login process. ((provider: SSL Provider, error: 0 - Certificate comes from a non-trusted certification organisation)

 

Background

- PBI Version 2.126.1261.0 64-bit (Februar 2024) --> Not Working

- Excel SQL Query --> Working

- PBI Version February 2023 --> Working

 

- Encryption off

- Login via Tab Database or Windows login brings the same issue

- Cache deleted

 

Can anyone help?

1 ACCEPTED SOLUTION
v-jingzhan-msft
Community Support
Community Support

Hi @Manuka 

 

You can follow the recommended steps indicated in this article https://learn.microsoft.com/en-us/power-query/connectors/sql-server#sql-server-certificate-isnt-trus...

 

Steps:

  1. Add environment variable with variable name PBI_SQL_TRUSTED_SERVERS and *.contoso.com* as the variable value (change contoso.com to FQDN of your organization)
  2. Click 'OK' to save your changes
  3. Reboot your device.
  4. Open Power BI Desktop and clear permissions for the data source, go to File > Options  and Settings > Data source settings.
  5. Select Get Data > SQL Server Database

 

Hope this would be helpful.

 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

View solution in original post

5 REPLIES 5
v-jingzhan-msft
Community Support
Community Support

Hi @Manuka 

 

You can follow the recommended steps indicated in this article https://learn.microsoft.com/en-us/power-query/connectors/sql-server#sql-server-certificate-isnt-trus...

 

Steps:

  1. Add environment variable with variable name PBI_SQL_TRUSTED_SERVERS and *.contoso.com* as the variable value (change contoso.com to FQDN of your organization)
  2. Click 'OK' to save your changes
  3. Reboot your device.
  4. Open Power BI Desktop and clear permissions for the data source, go to File > Options  and Settings > Data source settings.
  5. Select Get Data > SQL Server Database

 

Hope this would be helpful.

 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

If we are only utilizing Power BI Desktop, where do we modify to value for "PBI_SQL_TRUSTED_SERVERS"? Updating the gateway config file makes sense to me, but unsure where to modify envrionment variables for PBI desktop. 

You do that in the advanced system settings dialog of your PC

lbendlin_0-1716323030603.png

 

lbendlin_1-1716323051739.png

 

ahh got it, thank you for the quick reply!

lbendlin
Super User
Super User

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.