question

db042190-2983 avatar image
0 Votes"
db042190-2983 asked CarrinWu-MSFT edited

does tabular have an incremental load capability

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?

sql-server-analysis-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

dgosbell avatar image
0 Votes"
dgosbell answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered CarrinWu-MSFT edited

Hi @db042190-2983,

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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.