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

Incremental refresh understanding

Hai,

 

as a newbie looking for some understanding of incremental refresh. Read about it, watched a video, but want some confirmation.
We have fact tables and dimensions. In our coming architecture I presume "Import data" will be our first option.

Refreshing fact tabless by using the two parameters RangeStart and RangeEnd will work fine, I presume.

It will for instance only add the facts of the last day.

 

But how does it work with dimensions? We have a table with agreements, roundabout 10 million. Every row has a field called Last-Changed-Date. If I enable for this table Detect Data Changes, does that mean it will only refresh those rows where the Last-Changed-Date has changed?

 

Are there more issues I should consider concerning refresh?

 

Thnx Ron

1 REPLY 1
Highlighted
Microsoft
Microsoft

Re: Incremental refresh understanding

Hi @PowerRon ,

The following requirements need to be satisfied if need incremental refresh to work:

  • The data source must support query folding
  • The filter only applies to date time column

When you can enable the option "Detect Data Changes" and choose the field Last-Changed-Date, then the process of incremental refresh can monitor this field, and only get rows that the date/time is after the latest date/time in this field in the previous refresh. You can review the contents in the following links for more details.

All You Need to Know About the Incremental Refresh in Power BI: Load Changes Only

Power BI Incremental Refresh - Understanding Detect Data Changes

Data refresh and scheduling

Best Regards

Rena

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Kudoed Authors