We are using zScaler on our laptops and have a need to map to our GIT integrated Azure DevOps instance for both Azure SQL and Power BI in Visual Studio Code, Azure Data Studio, and SourceTree. Using SourceTree, I have successfully mapped to the Azure SQL GIT repository in our Azure DevOps instance. However, I am unable to map to the Power BI GIT-integrated repository. These are the steps already taken that enabled mapping to the Azure SQL GIT repository in Azure Dev Ops.
Added the zScaler certificate to my Git configuration:
From the Windows Start Menu, run the “Manage Computer Certificates” control panel app
Go to Trusted Root Certification Authorities -> Certificates -> Zscaler Root CA, right-click the certificate to Open it
On the Details tab, click “Copy to File”
The Certificate Export Wizard will open, click Next
Select “Base-64 encoded X.509 (.cer)” and click Next
- Save the file as “C:\Users*<username>*\AppData\Roaming\ZscalerRootCA.cer”, click Finish, and exit the control panel app
Execute GIT commands:
git config --global http.sslbackend openssl
- git config --global http.sslcainfo C:\Users*<username>*\AppData\Roaming\ZscalerRootCA.cer
Create Personal Access Token within Azure DevOps
GIT Commands Executed
git config --global http.sslbackend schannel
git config --system core.longpaths true
git config --global core.longpaths true
git config --global http.sslVerify=false (this returned an error: invalid key: http.sslVerify=false)
git config --global http.sslverify=false (this returned an error: invalid key: http.sslverify=false)
This is the path to the Azure SQL repository https://company.visualstudio.com/SystemDevelopment/_git/AzureDataWarehouse
This is the path to the Power BI repository https://dev.azure.com/company/_git/Power%20BI%20Development