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 ...
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.
