Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

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's avatar
    Anonymous
    10 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
10 years ago

...just adding onto my follow-up question - what do you use to build the tabular model?

 

Thanks...

 

Anonymous's avatar
Anonymous
Not applicable
10 years ago

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.