Forum Discussion
Incremental refresh without date field
Currently I am connecting my Business Central environment with Power BI using webservices. I want to use incremental refresh to load only new values or edits on excisting rows. I only have the field Posting date. A user has the possibility the post a row in the past. So if I use incremental refresh (based on latest year) and a user will post a row in 2018 it will not be included with the incremental refresh.
What I do have is a unique entry number (1, 2, 3, etc.). Is it possible to use this field? Or is it like the documentation tells me, only usable with datefields?
Thanks in advance!
3 Replies
Jelto , Refer if this can help
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/
Jelto Yes can only use Date/Time field. Also, the parameter names should be RangeStart and RangeEnd. These are reserved names.
Is it possible to add a new column modified date in the table and try to implement the incremental refresh?
https://docs.microsoft.com/en-us/power-bi/admin/service-premium-incremental-refresh#rangestart-and-rangeend-parameters
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂hmm, strange choice it's only possible with datefields. Unique numbers is much more reliable. I do not have any other options except the unique number. I will wait for an update from ms.😅
Thanks alot for your quick response.
