How to incrementally refresh Azure Analysis Services having synapse pool as source. Does “Default” processing option supports incremental refresh

Vipul Singh 21 Reputation points
2021-01-29T18:41:35.153+00:00

Cube: Tabular (Azure Analysis Server)--- Source DB: Azure Synapse Pool --- Data Operation: Insert and update is happening on the source system

Issue: Not able to get latest data from synapse pool in AAS cube, using "Default" processing option.

Clarification:

Which processing option(except full) to use, to have the latest data updated in tables in the cube?
Does "Default" processing option supports incremental refresh on tables in cube?

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,212 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. HarithaMaddi-MSFT 10,126 Reputation points
    2021-02-01T10:28:12.763+00:00

    Hi @Vipul Singh ,

    Welcome to Microsoft Q&A Platform. Thanks for posting the query.

    As per the document, default mode will only process previously unprocessed tables and cannot work as incremental. Unfortunately, there is no mode to do incremental load but the recommended approach for such requirements is to use partitions that will help if one of the reason to avoid full refresh is the refresh time.

    If having an incremental mode is helpful in processing data, I would recommend you to create an idea in feedback forum which will be closely monitored by analysis services product team and will consider implementing in the future.

    Ref: incremental-refresh-in-azure-analysis-services-from-azure-data-lake,azure-as-automated-partition-management,azure-analysis-services-incremental-refresh

    --

    • Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification.