Wednesday, 22 October 2025

Connect PowerBI to SQL Server - TrustServerCertificate

Under the server that Power BI installed, 

  • Go to System Properties -> Advanced -> Environment Variables 
  • Add this Variable Name PBI_SQL_TRUSTED_SERVERS
  • Set the Variable Value to the servers that are trying to reach out to this Power BI box
  • Restart the machine


Connect PowerBI to SQL Server - TrustServerCertificate

Under the server that Power BI installed,  Go to System Properties -> Advanced -> Environment Variables  Add this Variable Name PBI_S...