22-25 April 2026

Using M for data access in Analysis Services Tabular v.next

2017

TL; DR

Learn to use the M language to load data into the next version of SQL Server Analysis Services Tabular.

Session Details

The next release of SQL Server Analysis Services Tabular will allow you to use the M language and a Power Query-like UI to load data into your model. In this session you'll learn why this is such a significant change. Topics covered will include:
  • How the new functionality changes the way SSAS data loading works
  • New data sources that this supports
  • When you should transform data in M while loading and when you shouldn't
  • Creating partitions
  • Migrating from Power BI to Analysis Services

3 things you'll get out of this session