Forum Discussion
SSAS Tabular Model performance Issue
Hi I have a SSAS tabular model of almost 2 GB size. I refresh it's data using Azure Analysis Service on S1 tier(P.S. I have tried with S2 tier too but it still consume same amount of time) and refres...
Hi MAli_Ch ,
As rightly said by lbendlin , measures can have impact on refresh time. they are being calculated on the go.
please check your query if it is sql view or query try running it on SSMS first and monitor how much time it is taking for successful run. if your query has join or where condition you can consider created non cluster index on the columns.
Thanks,
Ankur