---
title: "Data Backfilling to Dashboarding Apps"
slug: "data-backfilling-to-dashboarding-apps"
description: "Load historical data from any date range to your dashboarding app with Dataddo. Easily load historical data from sources to destinations with one-time requests."
updated: 2023-09-02T22:10:32Z
published: 2023-09-02T22:10:32Z
canonical: "docs.dataddo.com/data-backfilling-to-dashboarding-apps"
---

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

# Data Backfilling to Dashboarding Apps

Dataddo's **Data Backfilling** feature allows you to populate historical data to [dashboarding apps](/docs/dashboarding-apps) such as [PowerBI](/docs/power-bi), [Looker Studio](/docs/looker-studio), or [Tableau](/docs/tableau). This ensures your dashboards and reports are both current and comprehensive, enriching your analytics and reporting.

          
          

In case your destination is a data storage (e.g. [Snowflake](/docs/snowflake), [Google BigQuery](/docs/google-bigquery), or [Databrics](/docs/databricks)), please refer to [**this article**](/docs/data-backfilling-to-storages).

## The Process

1. Go to the [**Sources**](https://app.dataddo.com/sources) page and trigger the extraction for your selected source.
2. If needed, specify your **date range**.
  1. If the UI does not offer a date range picker, you rill need to temprorarily [override the Source configuration](/v1/docs/data-backfilling-to-dashboarding-apps#override-source-configuration).
  2. For long timeframes, consider breaking the process into smaller segments and repeating as necessary.

![Core Concepts - Data Backfilling - Dashboarding Apps](https://cdn.document360.io/084ed225-3f99-4644-a2da-39ca0cd5ef45/Images/Documentation/Core%20Concepts%20-%20Data%20Backfilling%20-%20Dashboarding%20Apps.png)

## Trigger the Extraction

1. Go to the [**Sources**](https://app.dataddo.com/sources) page and click on the **Manual Data Load** button next to your source.
2. Set the **Snapshot Keeping Policy** to **Append**.
3. Select your date range.
  1. **Calendar picker available**: Select your date range. You may need to repeat this operation multiple times in case of longer timeframes.
  2. **Calendar picker not available**: [Override the source configuration](/v1/docs/data-backfilling-to-dashboarding-apps#override-source-configuration).
4. Click on **Load Data**.

![Historical data load - select date range](https://cdn.document360.io/084ed225-3f99-4644-a2da-39ca0cd5ef45/Images/Documentation/Historical%20data%20load%20-%20select%20date%20range.png)

### Override Source Configuration

          
          

Once data backfilling is complete, please revert the source configuration to its original settings to ensure smooth regular data extractions.

When the calendar date picker is not available, you can override this by **adjusting the source URL**.

1. Go to the [**Sources**](https://app.dataddo.com/sources) page and click on your source.
2. Navigate to the **Advanced Settings** tab and locate the **URL** field.
3. **Change the date range** query parameters (for more details, see [the following section](/v1/docs/data-backfilling-to-dashboarding-apps#change-date-range)).
4. **Save** the source configuration.

![Historical data load - source URL](https://cdn.document360.io/084ed225-3f99-4644-a2da-39ca0cd5ef45/Images/Documentation/Historical%20data%20load%20-%20source%20URL.png)

### Change Date Range

The date range in your source URL can be indicated by e.g.

- **startDate** and **endDate**
- **since_send_time** and **before_send_time**
- **start** and **end**

In the source URL, look for strings such as **{{1d1}}** which represent a placeholders for the definition of the dynamic timeframe. It will look like the following example.

```
https://us16.api.mailchimp.com/3.0/campaigns?offset=0&count=500&since_send_time={{1d1}}&before_send_time={{1d1}}
```

**Replace the placeholders with**:

A static string representing a specific time frame, for example:

```
https://us16.api.mailchimp.com/3.0/campaigns?offset=0&count=500&since_send_time=2020-09-01T00:00:00+00:00&before_send_time=2020-09-14T23:59:59+00:00
```

A dynamic date range. In the example below we want to extract last 90 days' data, including today.

```
https://us16.api.mailchimp.com/3.0/campaigns?offset=0&count=500&since_send_time={{90d0}}&before_send_time={{90d0}}
```

For more information, see [**Setting Date Range**](/docs/setting-date-range).

---