does tabular have an incremental load capability

Question

hi we will be migrating to 2019 enterprise shortly. i have an idea in mind that could win over management approval if tabular has an incremental load (from relational source) capability and more importantly if its fast. I want to be in and out of the relational source quickly . if it does offer such an incremental update feature, and if its fast, what does it use to make it faster than us just rolling our own incremental extract using datetimes etc?

Answer 1

You can do incremental loads with tabular, but you have to manually configure the queries that identify the new records (usually using a timestamp or identity column). There is no automatic incremental update setting. If you want the lightest touch possible on the source system you hare much better off hand tuning the queries and configuring when and how often they run than having some automatic system try and figure this out.

Answer 2

Hi @db042190 ,

Thank you for your posting.

As dgosbell said, you could do incremental loads with tabular model. For more information, please refer to below links:
How to Incrementally Load Tabular Models – 1400+ Compatibility Level
Tabular Object Model (TOM)

Best regards,
Carrin

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.