Analysis Services taking too much time to refresh SSAS tabular model

Ali Javed cheema 0 Reputation points
2024-08-25T23:34:49.5766667+00:00

Hi,

I have a data set of somewhere 40M records in SSMS. My tabular model earlier use to get refresh on S1 tier with 25-30 min. But now I'm using S2 tier and even still its refreshing the data at approx 60 min or sometimes failing and showing timeout error.

Can someone assist me where the issue lies as my ideal case is that I want to run analysis services on S1 tier again and time should reduce as well which is my top priority.

Thank you

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
458 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,982 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,938 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. MikeyQiaoMSFT-0444 3,190 Reputation points
    2024-08-26T09:14:30.1166667+00:00

    Hi,Ali Javed cheema

    40 million records is considered a large amount of data. You could try setting up an incremental load, it will reduce the amount of data to send to Azure.

    Or you can think about partitioning, you can refer to this link for more information: https://learn.microsoft.com/en-us/analysis-services/tabular-models/partitions-ssas-tabular?view=asallproducts-allversions.

    Regarding the loading timeout issue, you can try increasing the timeout value of the refresh operation. You can do this by modifying the refresh settings in Azure Analysis Services.

    Regards

    Mikey Qiao


    If you're satisfied with the answer, don't forget to "Accept it," as this will help others who have similar questions to yours.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.