I was chatting to a few of my Power BI buddies during the week about when we thought the December 2018 update would be released. It seemed to me that under normal circumstances the new version is released on or about the first Monday (US time) on or after the 3rd or 4th day of the month. So if the first Monday is 1st, 2nd, 3rd, then it is released on the second Monday (or Tues). That is my ‘feel’ anyway. I thought I would use Power BI to extract the historical blog articles announcing the releases and also thought that would be an interesting blog article in itself, so here goes.
Power BI Desktop Release History
Here is the final results from my report I created using Power BI. It seems the most common day is day 8 and the most common day is Monday.
OK, now let me talk about how I built this report.
Outline of My Approach
This process is easiest to follow as a video, so I have recorded a video and published it on my YouTube channel (embedded below too). In summary, these are the steps I followed.
- Find the webpage in a browser that has the information needed.
- Try to import from web using Power Query. In this case I needed to use the new “Query by Example” feature to import the data.
- Import a single page of blog articles
- Convert the query into a function so it can be reused to import multiple pages of articles (eg blogs 1-10, 11-20, 21-30 etc)
- Refresh the query to load all the data
- Enhance the raw data with some DAX.
- Visualise the results.
Video Showing The Process
Want to learn how to do this?
If you like the techniques I used in the video above, you would love my Power Query online training course. This course is 7.5 hours of video instruction where I teach you how to do these tricks and more. You can check out the free preview videos here.
This report is actually quite slow to refresh. I am a bit surprised actually and I may have a chat to the Power Query team to see if I have done something wrong, or if there are some optimisations that could be used.