Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

Reply
YuGuo
New Member

Incremental Refresh

Hi Guys

 

I am using Incremental Refresh on my Date which is super large (2GB). Everything went very very slow. The dataset in Power BI service (web) got updated. Here are the time slots I set

Whole data: 01-01-2020 to 15-08-2023 (2GB size data)

RangeStart: 01-08-2023 00:00:00

RangeEnd: 15-08-2023 00:00:00

I set the incremental refresh to keep the 1 year to archive the data and 30 days to refresh. I made the RangeStart and RangeEnd short to make the updates quicker. Is that a problem? 

I got one question here in my Power BI Desktop. Since RangeStart and RangeEnd were used in the filters to fold my datasets, I got really small folded dataset in my Desktop Verson. It is impossible to make data analysis. Can I delete the filters (not the parameters) in Power BI Desktop to release all data? I need to use at least 1.5 years' data to make data models. 

 

If anyone got the same quesion and help me out of the situation.

 

Thanks

1 REPLY 1
VijayP
Community Champion
Community Champion

@YuGuo 

I advise you to create RangeStart and RangeEnd bit wide instead of making very tight!




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!


Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.