Using M for data access in Analysis Services 2017 and Azure Analysis Services
June 18, 2018
When: Tuesday 10 July, 2018
Where: Tech Meetup Sapce - 8/9 Westmoreland Street
The biggest change in Analysis Services Tabular 2017 and Azure Analysis Services is the ability 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 so important. 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 About Chris WebbChris Webb is an independent consultant and trainer (www.crossjoin.co.uk) specialising in Analysis Services and Power BI. He is the author of “Power Query for Power BI and Excel” and a co-author of “SQL Server Analysis Services 2012: The BISM Tabular Model”,”Expert Cube Development with SQL Server 2008 Analysis Services”, and “MDX Solutions with Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase”. https://twitter.com/cwebb_bi