---
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
---

> ## 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){target="_blank"} such as [PowerBI](/docs/power-bi){target="_blank"}, [Looker Studio](/docs/looker-studio){target="_blank"}, or [Tableau](/docs/tableau){target="_blank"}. This ensures your dashboards and reports are both current and comprehensive, enriching your analytics and reporting.

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

## The Process
1. Go to the [**Sources**](https://app.dataddo.com/sources){target="_blank"} 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){height="" width=""}

## Trigger the Extraction
1. Go to the [**Sources**](https://app.dataddo.com/sources){target="_blank"} 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){target="_blank"}.
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){height="" width=""}

### Override Source Configuration
:::(Warning)
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){target="_blank"} 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){height="" width=""}

### 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){target="_blank"}.

***
{{snippet.NeedAssistance}}