---
title: "How to refresh data in Power BI using the Supermetrics API"
slug: "how-to-refresh-data-in-power-bi-using-the-supermetrics-api"
description: "Learn how to set up automatic refreshes for Power BI data using the Supermetrics API, ensuring your reports stay updated effortlessly."
updated: 2025-06-26T12:16:14Z
published: 2025-06-26T12:16:14Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt
> Use this file to discover all available pages before exploring further.

# How to refresh data in Power BI using the Supermetrics API

> Note
> 
> This article describes the steps to set up automatic refreshes for data imported to Power BI via Web URL using the Supermetrics API product. If you're using the Supermetrics Power BI connector and would like to set up refreshes for your data, take a look at [how to set up scheduled refreshes in Power BI using our connector](/v1/docs/how-to-set-up-scheduled-refreshes-in-power-bi).

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 subscription](https://powerbi.microsoft.com/en-us/power-bi-pro/) 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](/v1/docs/how-to-connect-data-to-power-bi-using-the-supermetrics-api).

## 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](/v1/docs/how-to-refresh-data-in-power-bi-using-the-supermetrics-api#edit-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.