Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
ThomasWeppler
Impactful Individual
Impactful Individual

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

‎09-24-2024 04:58 AM

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. 

Labels:
Message 1 of 3
324 Views
0
1 ACCEPTED SOLUTION
AnkitKukreja
Super User
Super User

‎09-24-2024 05:03 AM

 

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.

 

 

For Power BI trainings or support dm or reach out to me on LinkedIn.
If my response has successfully addressed your question or concern, I kindly request that you mark this post as resolved. Additionally, if you found my assistance helpful, a thumbs-up would be greatly appreciated.

Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904

View solution in original post

Message 2 of 3
311 Views
2 REPLIES 2
Joe_Barry
Super User
Super User

‎09-24-2024 05:08 AM

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

 

 




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



Learn about the Star Schema, it will solve many issues in Power BI!

Date tables help! Learn more



LinkedIn
Let's connect on LinkedIn


Message 3 of 3
296 Views
AnkitKukreja
Super User
Super User

‎09-24-2024 05:03 AM

 

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.

 

 

For Power BI trainings or support dm or reach out to me on LinkedIn.
If my response has successfully addressed your question or concern, I kindly request that you mark this post as resolved. Additionally, if you found my assistance helpful, a thumbs-up would be greatly appreciated.

Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904
Message 2 of 3
312 Views

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All