Choosing to Model in Power BI vs SSAS Tabular
October 9, 2019
Azure Every Day, Power BI, SSAS
Choosing to Model in Power BI vs SSAS TabularIn the release of SQL Server 2012, Microsoft introduced the SQL Server Analysis Services (SSAS) tabular model, a database that runs in-memory or in Direct Query mode. These databases display data with relational data sources. Allowing them to deliver a quick and powerful way of providing self-service Business Intelligence to client applications such as Microsoft Power View and Microsoft Excel.
With all the focus on cloud and Azure, have you ever wondered if you can run your traditional BI workloads within Azure? You may ask, should we be putting our traditional BI workloads that we’ve been using like the SQL Stack, SSIS, SSAS and relational databases in Azure; can we even do that?