TMSL refresh not completing whereas manual refresh in SSMS completes

Ben Dunmire 21 Reputation points
2021-11-02T16:30:47.673+00:00

We have a fairly large AAS tabular model and the largest fact table is partitioned by month (returns somewhere around 200M records by end of the month. When we process a partition manually through SSMS the "full" process completes in 2-3 hours. When doing the exact same thing through a TMSL script (run from ADF or even on the server) it continuously spins and never completes. The source is CSV files in data lake storage (ADLS Gen2).

We can monitor the AAS resource from Azure portal and can see it is active (reads, thread usage) for about 3 hours and then nothing, but the TMSL script won't complete and seemingly data will get read but not saved into the partition. Even empty partitions (no data) for this table take ages to process from TMSL.

We've tinkered with server settings and timeouts are all set fairly high. Any explanations as to why refreshing via SSMS is proving different results than executing via a TMSL script.

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
457 questions
{count} votes

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.