Open navigation

How to connect data to Power BI

Using the Supermetrics Query Manager, you can easily create queries and connect your data from various data sources to Power BI via the Supermetrics API.

We recommend using the KEY-JSON output format.

Before you begin

See Power BI’s documentation to learn more about connecting to a data source.


  1. Log in to the Supermetrics Team Site.
  2. Navigate to Integrations → Query Manager.
  3. In the sidebar on the left, build your query. Click Run to test it and review your data in the preview.
  4. From the URL format options, select K-JSON
  5. Copy the K-JSON URL.

    The query URL includes an API key that gives anyone with the URL access to your data. Treat this as you would a password and keep it safe. If you need to share the URL publicly, use the Short URL option that does not display your API key.

  6. Open your PowerBI workbook.
  7. Navigate to Home → Get data.
  8. Search for and select Web, then click Connect.
  9. In the From Web view, select the Basic setting, and paste the query URL you copied from the Query Manager into the URL field. Click OK.
  10. Give your data source a memorable name.
  11. Click Close & Apply in the top menu bar to complete the setup.

Did you find it helpful? Yes No

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