Forum Discussion
joshua1990
Post Prodigy
5 years agoIncremental refresh with numbers as date
Hello everyone! We have a fact table that contains a number to display the date. The format is CYYDDD. For instance 120001 = 01.01.2020. I already have a Power Query function to convert this numbe...
- 5 years ago
Hello joshua1990
Oracle connection is fine.
The only way to find that the incremental refresh is working fine is to, try to refresh your dataset manually or scheduled and see if it completed in lesser time than usual.
Have a look at this Video
Regards,
I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!
GilbertQ
Super User
5 years agoHi there
I have this blog post where I explain how you can still use the Key and not break incremental refreshing