Hosts multidimensional and tabular models in Microsoft's own on-premises analysis engine. Through Connect live, Power BI queries it directly, signing in with each person's Windows account details.
Also called SQL Server Analysis Services.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains SSAS in context, with comparison tables and the common traps.
Terms in this definition
- CONNECT
In SQL Server, the right to open a connection to a database. Fabric's equivalent is Read permission on an item, which allows connecting to a warehouse or SQL endpoint but not querying anything in it.
- Power BI
Microsoft's analytics and reporting service. It reaches data held on-premises through the on-premises data gateway.
Related terms
- Analysis Services
VertiPaq, Microsoft's in-memory analytics engine, sits underneath every Power BI semantic model and is likewise available as Azure Analysis Services or SQL Server Analysis Services. Tools connect to it over XMLA, using its client libraries.
- Live connection
Power BI reports can skip having a local model and instead connect straight to one already published in the Power BI service, Azure Analysis Services or SQL Server Analysis Services. Authors may still write report-level measures; editing the underlying model is possible only after converting it via Make changes to this model.