You can find Supermetrics as a connector in Power BI Desktop versions starting from 2.128.751.0 (April 2024 update).
Before you begin
Register a Supermetrics account by logging in to the Supermetrics Hub with your Microsoft or Google account using this link. Registering allows you to access the Supermetrics Hub platform, where you can connect to your data sources and build your initial queries for Power BI.
Microsoft admin approval
If you're using a Microsoft account that is managed by an admin, you might see an error reading Approval required or Need admin approval when you're logging in to the Supermetrics Hub.
Follow these instructions to resolve the admin approval issue.
Connect to data sources
To enable data import from a data platform of your choice, you need to establish a connection between the data source and Supermetrics. There are two places where you can do this: when creating your query, or on the data source management page on the Supermetrics Hub.
The data source management page on the Supermetrics Hub lets you manage all data source connections you have: add new data source connections, re-authorize existing ones, and disconnect or replace a connection that was in use.
The connection will be shared with people who are part of your Supermetrics team. You can have multiple connections to the same data source.
Instructions
To get started with your first query, create a query from scratch or start with one of our Power BI templates.
- On the Supermetrics Hub, click Destinations → Power BI in the left-hand navigation.
- Click Create or edit queries.
- Select a data source and log in to your account to create a connection between your data source and Supermetrics.
A login window opens to a new tab where you can connect to the account you want to get data. See our data source connection guides for data source-specific details.
- Define the query settings for the data you'd like to see in your report:
- Depending on the selected data source, you need to pick accounts to fetch data from or select a report type. Learn more about what you need to connect to various data sources.
- Define a date range — use a flexible date range, for example, "last 2 months", and always get data for the previous 2 months. Note that you can change the date range for a particular report using the connector.
- Select metrics, such as Impressions or Clicks. See the full list of metrics and dimensions for all our data sources. You can also make modifications to the metrics when selecting the query for the report in the Supermetrics connector for Power BI.
- Choose how to split the records. You can, for example, split the data by date or campaign name.
- Click Run query to check if you get the expected records, and click Save query. Name your query and schema (query group) and confirm. Schema is like a folder for your queries.
- In Power BI, click Get data in the Home ribbon and select More to view all connectors.
- Start typing "Supermetrics" in the search field and click the Supermetrics connector to launch it. The first time you open the connector, you're prompted to log in to your Supermetrics account.
The queries you save on the Hub will be available to you in Power BI Desktop once you sign in to the Supermetrics connector. Feel free to connect multiple data sources and save queries in each to create a combined report, such as a view of your ad accounts across various marketing data sources.
We have a wide range of templates available for Power BI.
- Take a look at our Power BI templates.
- Once you've found a template you want to use, click the template to download it to your computer.
- Go to the Supermetrics Hub using this link.
- Go to the Data sources tab.
- Select the data source used in the template and click Connect.
A login window opens to a new tab where you can connect to the account from which you want to get data. See our data source connection guides for data source-specific details. - Once you've connected to the data source, return to Power BI Desktop.
- Go to File → Import, and select Power BI template.
- Select the template you downloaded, and sign in to Supermetrics. The template will automatically populate with data.