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

Issue with Incremental Refresh : Loading all the data instead of overwriting policy

I have setup incremental refresh. But i don't think it is really working.

 

My data contains data from 2018 and 2019. My default parameters 

RangeStart = 2018-01-01 00:00:00:000

RangeEnd = 2019-12-31 00:00:00:000

 

My policy :  Store rows in last 1 years and refresh in last 2 months

 

However, after i publish i still see the data from RangeStart and RangeEnd.

 

I've seen few blogs that QueryFolding is mandatory for incremental refresh is it true?

 

My Source is Azure SQL, Query folding is available for first 5 steps and few transformations after that broke the Quey folding? Is this an issue?

 

Thanks,

Nishanth.

2 REPLIES 2
Community Support Team
Community Support Team

Re: Issue with Incremental Refresh : Loading all the data instead of overwriting policy

Hi @NishanthV ,

For incremental refresh, the data source must support “query folding” which is supported by most data sources that support SQL databases.

There are the blogs you can reference.

Important Considerations for Setting up Incremental Refresh on Power BI Desktop

Please create a sample to test again. If it still doesn't work, you could create a ticket to get timely help.

 

Best Regards,

Xue

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

NishanthV Regular Visitor
Regular Visitor

Re: Issue with Incremental Refresh : Loading all the data instead of overwriting policy

Hi Xue,

 

Thanks for the Reply. I tried this, however i am still not able to see that it is working.

 

Data is still loading from what i have given as the Range Start. 

 

Not sure what am i missing here...

 

Thanks,

Nishanth.

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: 319 members 3,329 guests
Please welcome our newest community members: