Installation Instructions

Pre-requisites:

  • Download and install power bi desktop
  • Download the Power BI SafetyChain connector, link below

To install the file to your Power BI Desktop application follow these steps:

  1. Take the downloaded SafetyChain V2.1.1.pqx file and move it to the following location .\Documents\Power BI Desktop\Custom Connectors

πŸ“˜

Note:

If the directory does not exist, you will need to create it. Create the Folder Power BI Desktop then in that folder add Custom Connectors

It may be necessary to place the directory in the OneDrive Documents Directory

If you have an earlier version of the connector, please remove it from the directory.

After adding the file, there will be 2 options for installing. Option 1 would be to install the thumbprint to ensure the connector is from a trusted source. Or option 2 to update your security settings to allow any extension to load without validation or warning (NOT RECOMMENDED).

Option 1: Adding the Certificate Thumbprint (Recommended)


πŸ“˜

Note:

As of SafetyChain Connector V2.1.1, the self signed certificate signing has been replaced with a SafetyChain Trusted Certificate. We recommend all tenants using the connector upgrade and install the newest version.

This process involves adding the thumbprint to your registry to allow Power BI desktop to load with the recommended security settings. For more details see this Microsoft link.

  1. Open your Registry Editor
  1. Navigate to the following directory - HKEY_LOCAL_MACHINE\Software\Policies\Microsoft\Power BI Desktop

πŸ“˜

Note:

If the directory doesn't exist please add it under HKEY_LOCAL_MACHINE\Software\Policies\Microsoft adding the folder Power BI Desktop.

  1. Next Right Click the Power BI Desktop directory > New > Click Multi-String Value then name the file TrustedCertificateThumbprints
  1. Right click the TrustedCertificateThumbprints and click Modify...
  1. Add the following thumbprint - F7430D65E56F0DF0B552A688C076D822302E9608

πŸ“˜

Note:

You can add multiple certificates by using \0 as a delimiter, or in the Registry Editor, right-click key, then select Modify to put each thumbprint on a new line.



Option 2: Update Security Settings in Power BI Desktop (Not Recommended)

πŸ“˜

Note:

Do not follow this part if you completed Option 1. This should only be done if your security policies will allow it and cannot complete Option 1 and is needed for testing.

  1. Open the PowerBI Desktop Application, then navigate to toβ€―File > Options and settings > Options > Security _then under _Data Extensions check Allow any extension to load without validation or warning
  1. Close the Power BI Desktop Application and re-open it to ensure changes have taken effect.