cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Incremental refresh not pulling today's data

Hi, I've configured an incremental refresh out of a SQL database. It is configured to pull data greater than RangeStart and less of equal to RangeEnd, the incremental settings are keep 2 years of data and refresh in the last one day based on insert DT. This is set up for 2 tables, the original one pulling from SQL and one more which references the source. The refresh finish successfully, but it brings data up to yesterday only.

 

I have another report with same configuration and it works just fine, what could I be missing? This one is configured on a single table though

3 REPLIES 3
Highlighted
Helper I
Helper I

Re: Incremental refresh not pulling today's data

Update: It is definitely something with the 2nd table referencing the source, I've disabled the incremenetal refresh on it and it is now pulling today's data... can't find a way to fix this =(

Highlighted
Helper I
Helper I

Re: Incremental refresh not pulling today's data

Update 2: It works the first time, the one that runs right after the report is published, then the schedule refresh won't load anything, it's been 2 days and my report stayed at Sep 24 even when it ran today

Highlighted
Regular Visitor

Re: Incremental refresh not pulling today's data

did you manage to get this working? I myself am having the same problem

Helpful resources

Announcements
Super Users of the Quarter - Q2 2020

Super Users of the Quarter - Q2 2020

Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!

June 2020 Community Highlights

June 2020 Community Highlights

Featured community members, changes to the Community, and more! Read up on recent Power BI community news.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors