This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 49%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
I have a tabular model based on 2017 VS. I am using PowerBI dashboard which has v bad performance. It takes lot of time to display data in visuals/ tables etc. Its size is 400GB. It contains around 200 tables including 30-40 fact tables. It has around 400 measures. So many nested measures- measures using another measure for calculation. so many calculated columns in fact tables. Data in many fact tables is around 800 -1000 crores for 3-4 years of data. We have done partitions on fact tables. I have to rebuild this tabular so any expert advice is highly appreciated. Thanks, Avhilash
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
Additional SQL Server features and topics not covered by specific categories
Answer accepted by question author
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
You can refer to the performance white paper.
https://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=17303
Best regards,
Percy Tang
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Dear Percy, Thanks for your reply but the mentioned doc is for Dimensional Model SSAS and not the Tabular Model. I have given some details about my model- size, complexity and based on that i just want to know some key ideas about the improvement of the performance. Also, i got some info that the max size is 500 gb for a tabular model and my tabular size is close to that and its not possible to optimize. Regards, Avhilash
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 95%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Just curious how an SSAS 2008 MD performance guide could be a solution to a Tabular optimization problem