Office 365 Service Description Power BI report

Office 365 Service Description Power BI report

I did a thing tonight that I swore I would never do. I used the “Publish to web” feature in Power BI. I had a good reason and I followed the guidelines I always tell people to follow, but I still feel a bit icky about it.

I was writing a document for a customer this afternoon and once again I ran into a situation where I wished that I could have the old Service Description Excel workbook that Microsoft used to put out. It was a really cool pivot table that allowed you to quickly see what features aligned to which Office 365 & Server based licenses. Unfortunately they stopped publishing it a few years ago. It is a giant pain in the ass to drill through all of the features across all of the SKUs to make sure that you are giving customers the best recommendations when it comes to licensing.

To be honest what I really missed was the ability to use conditional formatting on the thing and create a REALLY easy to consume version of the document for “at a glance” use. The goal is to be able to look at the features list and see which Microsoft SKUs they are available in.

This afternoon I ran across a nice table that does just that in the Office 365 Service Description part of for SharePoint, but the layout makes it relatively unusable. I got excited thinking that this was the answer to my old Excel workbook and immediately attempted to copy & paste into Excel, which failed miserably because of formatting. Then I got mad. I swore a ton. I called and yelled at Mark Rackley because that is one of the things I do when I get mad at SharePoint stuff. I believe that my last words on that call were “going to have to go PBID on their shit to get what I want”. Sorry for the colorful language gentle reader, but I warned you I was mad and swearing…

I grabbed the Web connector and pulled in the data that I wanted, wrote a bunch of queries, unpivoted some columns, hacked away for about 2 hours and ended up with a passable version of my old favorite tool. Then I went a bit nuts and decided to do the same thing for the Office 365 Platform Service Description which is considerably more complex and lengthy.

Finally I created a new Power BI Workspace and published it to the web. I still feel icky, but hopefully people will find this useful and that will make up for it. I have embedded the report below or you can visit to access it directly.

In the coming days I plan to add more to this. Let me know if you feel this is useful & what you would like to see added in the comments below or you can tweet at me @jasehimm.

9 thoughts on “Office 365 Service Description Power BI report

    1. Working on adding all of the different options in the Service Descriptions. The solution takes time to build the report because of the way the data exists in I will tweet when I add in additional pages of the report. Today there the Office 365 Platform, SharePoint and Exchange Features are there. I am also working on an Accessibility friendly version.

      1. Please add a GCC switch for us government folks. My workplace happens to be G3. Example: GCC didn’t get PowerAutomate(Flow) until April 2019. Therefore E3 would’ve said yes but our G3 would’ve said no until then.

  1. Fantastic and very helpful report, thanks. Is there any way to add the various add-in licenses to the report, E. G. Microsoft 365 Business Voice? This would be really helpful to see if it’s cheaper to have a lower level licence + add-on instead of an enterprise license which will include loads of functionality we’re unlikely to use.

    1. Not sure if that is going to be exactly possible the way that I am pulling this data in from the official sources. I will add it to the backlog and see if there is a way to do it once I have some of the other feature requests full-filled.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.