# "Import finished successfully, but data was truncated" warning

After running a data flow, the following warning is shown:

```
Data was partially imported because you have exceeded your current plan limit. Import finished successfully, but data was truncated.
```

Warning samples:

{% hint style="warning" icon="triangle-exclamation" %} <mark style="color:$tint;">**Data was partially imported because you have exceeded your current plan limit**</mark>

<mark style="color:$warning;">Import finished successfully, but data truncated because your dataset contains more than</mark> <mark style="color:$warning;"></mark><mark style="color:$warning;">**10,000**</mark> <mark style="color:$warning;"></mark><mark style="color:$warning;">rows.</mark>\ <mark style="color:$warning;">Please upgrade your plan to import more than 10,000 rows.</mark>
{% endhint %}

{% hint style="warning" icon="triangle-exclamation" %}
**Import finished successfully, but data was truncated**

<mark style="color:$warning;">One or more of your data sources contain more than</mark> <mark style="color:$warning;"></mark><mark style="color:$warning;">**100**</mark> <mark style="color:$warning;"></mark><mark style="color:$warning;">rows, which exceeds your current plan's limit. Please upgrade your plan to import</mark> <mark style="color:$warning;"></mark><mark style="color:$warning;">**100**</mark> <mark style="color:$warning;"></mark><mark style="color:$warning;">rows per data source.</mark>&#x20;
{% endhint %}

This warning indicates you have hit the [Data Volume limit](https://docs.coupler.io/functionality/coupler.io-features-and-limits#data-volume-l1bbp) . This limit differs[ per billing plan](https://www.coupler.io/pricing).&#x20;

There can be an edge case where you receive this warning even when your rows in the destination file are within your limit.&#x20;

**Why does it happen:**

**There are 4 stages your data undergoes when you set up an integration in Coupler.io:**

* Step 1 - Sources setup&#x20;
* Step 2 - Data Sets (Transformations)
* Step 3 - Destinations setup
* Step 4 - Flow Settings

<figure><img src="https://2487187314-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FCgnmco7kCnvytNIN8YdT%2Fuploads%2F1FKlA9bfxlTivV2vLKQ9%2Fimage.png?alt=media&#x26;token=576b1aee-cc8e-41fb-b3b2-07c024387fd1" alt=""><figcaption></figcaption></figure>

This edge case may happen when you reduce your dataset during step 2 - Data Sets, but your original dataset from step 1 - Sources is bigger.

Coupler.io fetches your data fully based on the parameters you've set in step 1 - Sources setup, before showing your data on step 2 - Data Sets. In the Destinations, you see the data that matches the data in step 2 - Data Sets.

This is why your Data Volume limit is getting reached. Because internally, Coupler.io still uses resources to pull all your data during the first stage. The filter is applied later, in the second stage.

<details>

<summary>Example scenario</summary>

You are on the free plan with a 100 rows/run Data Volume limit.&#x20;

You are running 2 Campaigns in Facebook Ads and want to pull insights for 1 Campaign for the last week. On Step 1 - Sources setup, you used only the date settings. On Step 2 - Data Sets, you applied a filter by campaign name and ran the data flow to a spreadsheet.&#x20;

<div align="left"><figure><img src="https://2487187314-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FCgnmco7kCnvytNIN8YdT%2Fuploads%2F6Lj4XfOHJJ0JHoPuZQxu%2Fimage.png?alt=media&#x26;token=11c1abd1-a330-49ac-a73b-81285e9860fb" alt="" width="375"><figcaption></figcaption></figure></div>

The destination spreadsheet showed 70 rows of data, yet you received the "Import finished successfully, but data was truncated" warning.

Why? Your original dataset **before Transformations** was 150 rows, as it had data for all your Facebook Ads Campaigns for the past week.&#x20;

To not receive this warning, you can apply all filters on Step 1 - Sources setup instead, so your original dataset is under 100 rows. In our example case, you can apply both date filters & filter by campaign name there.&#x20;

<div align="left"><figure><img src="https://2487187314-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FCgnmco7kCnvytNIN8YdT%2Fuploads%2Fj2JfkgzjON1dUcU0G1DB%2Fimage.png?alt=media&#x26;token=8dc2bc4c-c42c-4af9-8fa0-6b18fd24ca87" alt="" width="375"><figcaption></figcaption></figure></div>

&#x20;

</details>
