When I download new data, I only want data from the last 2 days and keep the old data.

[ThomasWeppler]

Hi Power BI community

When I refresh my data I get a timeout issue because the data I get from the API call is to large and slow.
I can solve it be reducing the data size.

So I want to only download the data from the last two days and add it to my old data.

All help is greatly apprciated. 

[Joe_Barry]

Hi @ThomasWeppler 

Please refer to my answer here regarding Incremental Refresh. You can save old data and within your api call, if it's possible to call just the last 2 days, then this solution should help.

Joe

https://community.fabric.microsoft.com/t5/Power-Query/Need-help-in-finding-way-to-accumulate-data-in...

[AnkitKukreja · Accepted solution]

Hi! @ThomasWeppler 

You can use incremental refresh to refresh the data for last 2 days and simultaneously use parameters to restrict your data before downloading.