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


Generate Secure Files using PGP (Pretty Good Privacy)

Pretty Good Privacy (PGP) is a data encryption program used for signing, encrypting, and decrypting emails, files, and text to ensure secure...