Open navigation

How to load your data to Power BI

Once you’ve connected to your data source and saved your query, it's time to get your data in Power BI.


  1. Open Power BI Desktop.
  2. In the Home ribbon, click Get Data.
  3. Search and select Supermetrics, and click Connect.

    You can find Supermetrics as a connector in Power BI Desktop versions starting from 2.128.751.0 (April 2024 update). Check these instructions if you can't find the Supermetrics connector.

  4. If you're connecting to Supermetrics for the first time, you'll see a third-party notice. Select Don't warn me again with this connector if you don't want this message to be displayed again, and click Continue.
  5. Click Sign in to log in to your Supermetrics account.
  6. Use single sign-on (SSO) in the Supermetrics window that appears: click Sign in with Microsoft or Sign in with Google and choose the same account that you use (or plan to use) to sign in to the Supermetrics Hub.
  7. If you're a member of more than one Supermetrics team, select a team.
  8. Once you've signed in, click Continue.
  9. Click Connect.
    Once the Navigator dialog box loads, you'll be able to preview all queries you've saved in your Supermetrics account on the Hub. They're organized by the data source in the folders on the left. 
  10. Select the checkboxes next to any queries with data you'd like to use for your report.
  11. You can modify the account, date range, or metrics used for the current report. Select the option above the preview and click Apply. Make sure you always use accounts from one connection.

Next steps

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.