Forum Discussion
Solved
Initial data load for incremental refresh on a nearly useless datetime column
Hi there, to whoever is reading this, thanks for stopping by. I am running into an issue with trying to initially load a whole dataset into a Power BI report that uses incremental refreshing. I h...
GeraldGEmerick
Memorable Member
Memorable MemberJTsoi I would look into writing an extension/script that updates your system last modified dates in Dynamics 365 to something reasonable.
Hi GeraldGEmerick,
I did consider that, but unfortunately the [systemLastModified] in Dynamics 365 is a system field that is read-only, so modifying them directly is out of my reach for now. I did have a a slightly insane moment of thinking about writing a script to loop through every single financial transaction in our system (around 4 - 5 million rows of g/l entries and 60000-ish budget entries) just to make an empty update just to force the systemLastModified field to change, but I'm going to leave that as a last resort, it feels a rather bit heavy of a hammer to use for this problem.