Forum Discussion
Anonymous
3 years agoNot applicable
Incremental refresh Power BI dataset, how does it work?
Hello I have built a view (an aggregate) on a 35 billion row SQLServer table, 7 years of history. Every day around 14 million rows are added. The view is used in Incremental Refresh (1 Days) The...
Wilson_
3 years agoMemorable Member
Hello,
I had two initial thoughts on your question:
- Have you read Microsoft's documentation on incremental refresh? I scanned through and the first section the "Required settings" section seem the most relevant to your overall question.
- More specifically, a common issue to check: Is query folding intact on that particular query? The easiest way to see if that's true is to right click on the last step in the query and see if the option to see native query is enabled and not greyed out. Is your Power Query break query folding, it's possible it's unable to do an incremental refresh and is doing a full refresh every time instead.
----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)