cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
GTS_ONE Regular Visitor
Regular Visitor

Incremental Refresh with Detect Data seems Inconsistent and Erratic

Hi All,

 

Been doing quite a bit of testing using Incremental Refresh with Detect Data turned on.  It was setup as a very, very simple controlled test using a table that just had a Main Date, Modified Date, and a Value.

 

I would manually update the test table in a variety of ways, then refresh my PBI report and view the results.

 

What I'm finding is that sometimes everything works exactly as expected: new rows get picked up, changed rows get picked up, rows that fall outside the date ranges get ignored, etc. etc.

 

But then for some reason, I always find that the Detect Data seems to stop working.  Then for awhile I do not see new rows being added or valid updates to the data being reflected.  I'll continue to refresh and it simply doesn't work.

 

But then I'll make another change to the table and suddenly everything seems to "wake up" and then it will start working again.  But this will only last awhile until it then seems to lose track and stop updating again.

 

And again, this is a very simple and controlled data table which I am manually updating, so I know exactly the rows that are being sent.

 

I was wondering if anyone has experienced something similar, or if maybe someone knows about some nuances with how Detect Data works that may explain this kind of erratic behavior...

 

Thanks!

1 REPLY 1
GTS_ONE Regular Visitor
Regular Visitor

Re: Incremental Refresh with Detect Data seems Inconsistent and Erratic

Here's a good example of what I'm referring to.

 

Note how I added a new row at Index 13 and you can see it in the control table on the left.  When I did the refresh, the Incremental Refresh table on the right did pick it up.

 

A few minutes later, I added row Index 14 with the same dates.  You can see it in the control table on the left.  But then note how the Incremental Refresh table on the right does not pick it up.

 

inc refresh inconsistent 2.PNG

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 77 members 1,131 guests
Please welcome our newest community members: