In-Person Power BI And Azure Analysis Services Training In London

I’m pleased to announce two in-person training dates in London next year.

First of all, I’ll be running a three-day “Introduction to Power BI” course from January 29th to January 31st 2018.  Suitable for BI pros, analysts and anyone who needs to use Power BI to build reports, I’ll be covering data loading, data modelling, a bit of M, a lot of DAX, report design, publishing, security and administration. Full details and registration can be found here:

Not long after, on February 22nd 2018, I’ll be teaching a full-day preconference seminar at SQLBits in London on Azure Analysis Services. The agenda can be found here:

…but, to be honest, there’s likely to be a lot of cool new functionality released for Azure SSAS between now and then so that will all have to be fitted in too. SQLBits is, of course, the biggest SQL Server/Microsoft data platform conference in Europe, ridiculously good value for money and loads of fun. Pricing and registration details can be found here:

PASS Summit 2017 Day 1 BI News

There haven’t been any really big BI announcements at the PASS Summit this year – I guess we get so much amazing new stuff every month with Power BI that there’s no need to make ‘big’ announcements at conferences any more. However there have been several cool new features unveiled that I thought it would be good to highlight.

Azure SSAS automated scale-out

I’m a big fan of Azure SSAS, and what I particularly like is the way the dev team are making tasks that are complex with on-premises SSAS much easier when you go to the cloud. SSAS scale-out is a great example: on-premises you have to solve this by buying multiple servers, licensing and maintaining multiple instances of SSAS, and then setting up network load balancing on top of them. Today the Azure SSAS team announced their automated scale-out feature is live, and now all you need to do to scale out is drag a slider to the right:


Of course this is all scriptable too, so if you know you need to have to handle more users on a Monday morning you can scale-out appropriately and then when the rush is over you can reduce the number of query replicas and pay less.

Power BI Report Server

There’s a new release of Power BI Report Server available, and you can read all about it here:

The blog post highlights the fact that you can connect to SSRS shared datasets via OData – which is basically what I was talking about here.

Preview of in-memory/DirectQuery hybrid datasets

Christian Wade of the SSAS dev team gave a very cool demo of building Power BI reports on a trillion row dataset. Not many details are available about how this works, or when it will be released, but it seems to be through a feature where you can combine tables stored in-memory and tables that use DirectQuery storage (in the demo this was DirectQuery on Spark) in the same dataset. It sounds a bit like HOLAP: queries that request aggregated values hit the fast, in-memory data, but when you want to look at detail-level data queries use DirectQuery. Someone is very excited about this:


PowerApps/Power BI integration

Something that was going to be demoed – but the demo failed so we didn’t see it – was the promised integration between PowerApps and Power BI. Apparently this will be released soon.

ESRI Plus subscription for Power BI

Mentioned in the keynote but again with very few details is the fact that ESRI is going to offer a special subscription for users of the ESRI maps visual in Power BI. It looks like this is it and it is slated for release in November:

Here’s what the ESRI site says the benefits will be:

  • Access global demographics
  • Access verified ready-to-use data, curated from authoritative sources
  • Access more basemaps including satellite imagery and terrain
  • Map and view more locations on your visualization

Pre-Conference Training Day On Data Loading With Power BI/Excel Get & Transform/Power Query At PASS Summit

I’m pleased to announce that I’m running a pre-conference training day on “Loading and transforming data with Power BI and Power Query” at this year’s PASS Summit in Seattle. For the full agenda and details on how to register, see:

This full-day session will teach you everything you need to know about loading data into Power BI or Excel; it’s specifically focussed on self-service BI scenarios, but if you want to learn M for SSAS 2017 you might find some of what I cover useful too. Topics covered include using the UI to build queries; using parameters and functions; the M language; data privacy settings; and creating custom data connectors. I hope to see you there!

Microsoft Data Insights Summit Videos Published

The Microsoft Data Insights Summit finished today, and the videos of the sessions have already (!!) been published online here:

I can’t remember ever attending a conference where there was so much new functionality revealed. I’m not talking about things like Power BI Premium – that’s last month’s news – I’m talking about lots and lots of really cool new features that I had not seen before, so many that I feel completely overwhelmed by them all. There are a few blog posts out there that try to summarise the announcements (apart from the post on the official Power BI blog, check out Matt Allington and Dustin Ryan’s posts) but really your only option is to watch as many of the session videos as you can! I thought I would call out some videos about the new features for you to start off with:

  • The keynote on the first day was pretty amazing (Amir Netz’s demo should be watched in full) with some highlights being:
  • The session on the Visio custom visual for Power BI had a lot of detail on how Visio/Power BI integration will work, and was very impressive. You can sign up for the preview here.
  • Power BI/PowerApps/Flow integration, with Power BI content appearing in Power Apps and vice versa is something I am going to watch with interest.
  • One major announcement (at least for me) that slipped out in the session on the Common Data Model is that there’s going to be a standalone, SaaS version of Power Query available that will be able to load data into the Common Data Model
  • Matt Masson’s session has a lot of information on building custom data connectors as well as the announcement that M is officially called M!
  • Azure Analysis Services will soon have a much better web interface that will allow you to create simple models, and also to import models from Power BI .pbix files. Christian Wade’s session on Azure Analysis Services also has a great extended demo showing off new SSAS Tabular features, including one showing using BISM Normalizer to merge parts of a mode in a .pbix file into a Tabular model.

This is by no means comprehensive. I haven’t been able to watch all the videos yet either, so there may be other important new features in other sessions that I completely missed.

Last of all, although they don’t contain any new announcements, you can also watch my two M-themed sessions from the conference: Working With Parameters And Functions and Working With Web Services in Power BI/Power Query/Excel Get&Transform.

Two Upcoming Power BI Webinars

This is just a quick post to let you know about two webinars I’m presenting soon. First, on the 21st of June (today!) at 1pm PST I’m presenting a webinar on “Introduction to M” as part of the Power BI community webinar series; more details on it and how to register can be found here:

Second, I’m presenting a webinar with Pyramid Analytics about their on-premises BI solution and how it integrates with Power BI on the 30th of June called “The Public Cloud Is Not For Everyone”:

[Full disclosure – I’m being paid for this – but it won’t be marketing fluff, just honest discussion, similar to the webinars I did with Pyramid last year]

Upcoming User Group, Conference And Teaching Dates In Scandinavia, UK and USA

I’m going to be doing a lot of speaking at various events over the next few months, and so I thought I would let you know about where I’ll be in case you want to attend.


Next week I’m doing a mini-tour of four Scandinavian user groups in a week:

SQL Relay

I’m going to be speaking at two SQL Relay events in October. SQL Relay is a series of one-day SQL Server events held in various places all over the UK and is always well worth attending. I’ll be speaking at:

MDX Training Course

There are still a few places available on my “Introduction to MDX” training course in London, running from October 12th-14th. It will teach you everything you need to know about MDX queries and calculations for Analysis Services, starting from the absolute basics and going up to SCOPE statements. Check out the Technitrain site for details of other courses including Allan Hirt’s Mission Critical SQL Server, Rafal Lukawiecki’s Practical Data Science With Cortana Analytics, and more to be announced soon.

My MDX and SSAS cube design and performance tuning courses are also available in video form from Project Botticelli, and you can get a 10% discount if you register using the code TECHNITRAIN2015

PASS Summit 2015

It is always an honour to be selected to speak at the PASS Summit, and this year I’ll be doing two sessions: “Using Power Query to build a Reporting Solution in Excel” and “Analysing audience reaction to the PASS Summit keynote”. The latter should be particularly fun, since it will involve me using Bing Pulse, Power BI, Excel, NodeXL and Azure Machine Learning in a lot of demos! I hope to be making a guest appearance in a third session, which I’m also excited about, but I’ll leave that as a surprise…

Advanced SSAS Multidimensional Security Tips & Tricks Webinar This Thursday

In association with the nice people at SQLRelay I’ll be presenting an hour-long webinar on advanced SSAS Multidimensional tips and tricks this Thursday July 9th 2015 at 1pm UK time (that’s 8am EDT for you Americans). It’s free to attend and open to anyone, anywhere in the world. You can join the meeting by going to

In the webinar I’ll be covering topics such as:

  • The difference between Allowed Sets and Denied Sets in dimension security
  • Handling security-related errors in your MDX calculations
  • The different ways of implementing dynamic security
  • Why you should avoid cell security, and how (in some cases) you can replace it with dimension security

…and lots more.

If you’re in the UK, you should definitely check out SQLRelay, an annual series of one-day SQL Server events that happens at a number of different places around the country each autumn. For more details, see

I’m presenting this webinar in my capacity as a sponsor of SQLRelay, so expect me to spend a small amount of time promoting Technitrain’s autum course schedule. There are some cool courses on SSIS, MDX, SQL Server high availability and data science/machine learning coming up, you know…

UPDATE: you can download the slides and demos from the webinar at and watch the recording at

For whoever was asking about using a measure group to store permissions for dynamic security, this blog post has all the details: