A better way to view Release Planner data

Visualizing Microsoft Power Platform and Dynamics 365 release plan items with Power BI. Now available on the public web.

Have you ever struggled to find the right release items for Microsoft Power Platform and Microsoft Dynamics 365 products when using the official Release Planner website?

Did you ever get frustrated when Microsoft decided to categorize the release items in a non-intuitive way?

Ever wished there was a quick way to see the most recently updated items on the release plans?

Yes! Yes! And, yes!🙌

Screenshot of Release Planner website, on a regular day, not returning any content.

Those answers were what drove me to explore alternative ways to access and present the release item data.

Discovering the Release Planner API

While Microsoft doesn’t show it in their website UI, there is actually a documented data feed to access the Release Planner content. You just have to discover it from the “What’s New” PDF deck of the website.🧐

The only documentation available on the existence of Release Planner API

The feed we get from https://releaseplans.microsoft.com/en-US/allreleaseplans/ contains almost all of the information needed for replicating the Release Planner site in another format. To make it as easy as possible to work with the data, let’s push the feed into Power BI:

Transforming the Release Planner API data with Power Query

Making it pretty

Originally, I created just a quick & dirty version of the report for my own use, with basic table and slicer visualizations that allowed me to filter and browse the release item list. I posted about it on LinkedIn during the 2024 Wave 2 launch event. Then a community member reached out:

Comments on my LinkedIn post about the 1st report draft

Thanks to the awesome work by Wouter Kessener, the report now had a user experience on a whole new level!👏

Making it available

I had earlier seen how MVP Loryan Strant had published his Microsoft 365 Roadmap visualization as a shared Power BI report, conveniently available via the URL https://www.m365roadmap.com/ . This seemed like such a great idea that I had to copy it.

So, I registered the domain releaseplans.net domain. Then, after some trial and error, I managed to get my very first Hugo based website up and running. And here it is now:

Website published: “Release Plans Visualized”

You’re free to bookmark this site and access it for an online copy of the Release Plans report, refreshed on a daily basis. Alternatively, if you want to download your own .pbix copy of it, it’s available on GitHub:

Where to grab the Power BI report on GitHub

If you spot any errors or come across ideas on how you’d improve the report, feel free to open a GitHub issue and I’ll promise to take a look at it.

Reply

or to participate.