Installation and setup
Download the Celonis EMS Connector Installer from Celonis EMS Marketplace.
Run the Celonis EMS Connector Installer.
Installer has created the necessary folder structure and inserted the connector's pqx-file in: (C:\Users\Username\Documents\Power BI Desktop\Custom Connectors\Celonis EMS Connector.pqx).
This is the official folder for local custom connectors.
Using the registry to trust third-party connectors
Trusting third-party connectors in Power BI is done by listing the thumbprint of the certificate you want to trust in a specified registry value. If this thumbprint matches the thumbprint of the certificate on the connector you want to load, you will be able to load it in the ‘Recommended’ security level of Power BI.
Add thumbprint to registry
Open the Registry Editor as administrator.The registry path is HKEY_LOCAL_MACHINE\Software\Policies\Microsoft\Power BI Desktop.
Check that the path exists. If it does not exist, create it. We chose this location because it is primarily controlled by IT policy, and because it requires local machine administration access to edit.
Add a new value under the path specified above. The type should be “Multi-String Value” (REG_MULTI_SZ), and it should be called “TrustedCertificateThumbprints”.
Add the thumbprints of the certificates you want to trust. You can add multiple certificates by using “\0” as a delimiter, or in the registry editor, right click -> modify and put each thumbprint on a new line.
Add thumbprint to registry with registry entry
Create a registry entry using the code below and saving it as a *.reg file.
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Power BI Desktop]
"TrustedCertificateThumbprints"=hex(7):32,00,33,00,44,00,39,00,41,00,44,00,42,\
00,43,00,35,00,33,00,44,00,33,00,35,00,36,00,43,00,35,00,46,00,31,00,31,00,\
42,00,44,00,39,00,33,00,32,00,41,00,44,00,36,00,41,00,46,00,30,00,31,00,33,\
00,32,00,46,00,35,00,45,00,32,00,31,00,38,00,38,00,00,00,00,00
Open the Registry Editor as administrator. Click on “File” and then “Import”. Select the registry entry you created.
The thumbprint of the certificate is automatically inserted.