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.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

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 Self Signed Certificate (Recommended)

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 - 3C39228FFF8418273029E0B3CEE82A58246F9DFF

πŸ“˜

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.