Post reply

SSAS Tabular - partition to refresh modified historical data

  • September 9, 2022 at 5:35 pm

    #4085969

    Hi, I have an SSAS tabular model that contains a fact table with 20 mil rows. I have partitioned this so only the new rows get added to each day... however occasionally, a historical row (from years ago) will be modified. I can identify this modified row in SQL (using the last modified timestamp) however would it be possible for me to refresh the row in SSAS to reflect this change without having to refresh my entire data model?

  • September 9, 2022 at 5:56 pm

    #4085971

    It will require a little bit of work, but yes...if you can identify the partition it belongs to, you should be able to dynamically build the refresh query in SSIS or PowerShell to refresh that partition only.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply