Supermetrics connector has been certified by Microsoft and comes with Power BI Desktop starting from version 2.128.751.0 (April 2024 update). We highly recommend using the certified version if you can, as it supports scheduled refreshes and other native Power BI features.
This guide will help you to manually install the Supermetrics connector for Power BI if you need to set up a custom version of the connector.
Follow these instructions if you can't launch the Supermetrics connector in Power BI.
Instructions
- Log in to Supermetrics Hub using either Microsoft or Google account. If you're a first-time user, a Supermetrics account will be created for you automatically.
- Navigate to Destinations → Power BI.
- Click Download now to get the installation file.
- Once downloaded, double-click the file to run the set-up wizard.
- Click Next to confirm installation and click Finish to close the window.
This set-up wizard will create a folder for custom Power BI connectors, add the Supermetrics connector file and its certificate thumbprint on your computer.
Now, you can open Power BI Desktop, click Get data and find Supermetrics in the list of data sources.
You can see the full set-up steps in the video tutorial below. Please note that the video describes the manual installation process.
Troubleshooting
"Need admin approval" error when trying to log in to Hub
If your Microsoft account is managed by an admin, you might see an error reading Need admin approval or Approval required when you're logging in to the Supermetrics Hub. Follow these instructions to resolve admin approval issues.
I don't have permission to run installation files on my machine
If you don't have enough permissions to run installation files, you can install the tool manually by creating a specific folder on your PC that Power BI checks for custom connectors, and adding the Supermetrics connector file you can get from our support. Follow the instructions below to install the Supermetrics connector manually. You can also install the trusted Supermetrics connector for Power BI.
- Create the following path on your PC: [Documents]\Power BI Desktop\Custom Connectors.
Make sure you use the documents folder for the current user under disk C. - Reach out to our customer support to get the Supermetrics.mez file
- Download and save the Supermetrics file to the Custom Connectors folder you created.
- Adjust the Power BI settings to allow custom connectors to load. As described in this Microsoft article about custom connectors, open Power BI Desktop, go to File → Options and Settings → Options, and find the Security tab.
Note
If you prefer not to change your local security settings, you can "trust" our connector. To do this, you'll need to create a registry key with our certificate on your Windows machine. Take a look at our instructions on how to install the trusted connector.
- Under Data Extensions, select (Not Recommended) Allow any extension to load without validation or warning.
- Click OK.
- Restart your Power BI Desktop.
Now, when you open Power BI and click Get data, you'll already be able to find Supermetrics.
The installation of the trusted version of the connector doesn't require changing security settings in your Power BI application. To get started with the installation, contact our support team with "Request for signed Power BI integration" as the subject, and we'll send you the necessary file and help you with the installation.
Below, you can find the general description of the process so that you can understand it and share it with your IT specialist if needed.
- Create the following path on your PC: [Documents]\Power BI Desktop\Custom Connectors.
- Make sure you use the documents folder for the current user under disk C.
- Download the signed version of Supermetrics connector provided by our team.
- Save the downloaded file to the Custom Connectors folder you created.
- Create a regedit key with the certificate thumbprint:
- In Windows, open registry (enter "regedit" and click Enter), and go to HKEY_LOCAL_MACHINE\Software\Policies\Microsoft
- Create a folder called Power BI Desktop in it (right-click the Microsoft folder and select New → Key), so that the path is HKEY_LOCAL_MACHINE\Software\Policies\Microsoft\Power BI Desktop.
- 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 certificate thumbprint provided to you by our team.