Forum Discussion
DirectQuery - create variances?
Hi everyone, I am pretty new to Power BI Desktop and just started exploring DirectQuery. We have very large data tables so Import doesn't seem like a practical option to use, however, it looks l...
Anonymous Tabular models are a SSAS (SQL Server Analysis Services) solution by Microsoft. Details here
Tabular models require BI or Enterprise SQL editions and are built in SSDT (SQL Server Data Tools) in Visual Studio.
The same technology is behind the Power BI Desktop, but there are currently limitations on file size etc.
Using an SSAS Tabular model solution offers the greatest scalability and flexibility within Power BI. For large scale datasets it is the only complete modeling solution for Power BI at the moment.
Hi Eno1978,
What do you mean when you say that you use 'tabular models for all large scale models'?
Thanks,
...just adding onto my follow-up question - what do you use to build the tabular model?
Thanks...