Forum Discussion
SQL Database connection issues with current PBI Version
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-trusted-on-the-client-power-bi-desktop-or-on-premises-data-gateway
Steps:
- 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)
- Click 'OK' to save your changes
- Reboot your device.
- Open Power BI Desktop and clear permissions for the data source, go to File > Options and Settings > Data source settings.
- 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!
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-trusted-on-the-client-power-bi-desktop-or-on-premises-data-gateway
Steps:
- 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)
- Click 'OK' to save your changes
- Reboot your device.
- Open Power BI Desktop and clear permissions for the data source, go to File > Options and Settings > Data source settings.
- 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.
