- Perspectives on Power Platform
- Posts
- A better way to view Release Planner data
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:
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:
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:
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