Open navigation

How to refresh data in Power BI using the Supermetrics API

Scheduled refreshes in Power BI ensure that your published data stays up to date with your data sources. This article covers how to implement these refreshes when using Power BI through the Supermetrics API.


Before you begin

You’ll need a Power BI Pro license to schedule refreshes.


You’ll also need to use the K-JSON format in Query Manager, as Power BI’s HTML format isn’t compatible with this type of refresh. Learn more about how to connect data to Power BI.


Instructions

These steps apply to Power BI Desktop.


Refresh data

  1. Open a report in Power BI.
  2. Click Publish.
  3. Select the workspace you want to publish into.
  4. After the platform finishes publishing, click the Open in Power BI link. The report will open in a browser.
  5. Click Datasets in the sidebar.
  6. Find the dataset you want to schedule. Click the 3-dot menu next to its name.
  7. Click Settings → Scheduled refresh.
    If you get an error saying that your credentials are missing, edit the data source credentials.
  8. Click Choose your settings → Apply.


Edit data source credentials

  1. Click the 3-dot menu next to the name of the data set.
  2. Go to Settings → Data source credentials
  3. Click Edit credentials
  4. Set the authentication method to anonymous and data source privacy level to public. 
  5. Click Sign in
  6. Return to the list of data sets and refresh the data set.

Did you find it helpful? Yes No

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