Power BI - SQL Server Self Signed Certificate Connection Error (new environment variable)

Jake Gray here. Welcome to my Data Make You Smile channel. I am a CFO, Entrepreneur and "Citizen Developer" Building a Team of Fellow BI / No Code / Automation Geeks to help small business clients streamline their operations and get the most from their current staff and software. **IN THIS VIDEO** I encountered a unique data connection error in Power BI Desktop and share detailed steps to resolve the self-signed certificate authority chain issue. Watch to learn how to configure the connection and add environment variables for a successful connection to a SQL server from Power BI desktop. This is a tutorial with detailed steps to add a new environment variable: PBI_SQL_TRUSTED_SERVERS This environment variable is necessary to address the following error: Power BI - SQL Server Self Signed Certificate Connection Error: “certificate chain was issued by an authority that is not trusted.”