The updates to Power Query has a monthly update cycle and I decided to see if I could use Power Query and Power View to analyze when to be ready at http://blogs.msdn.com/b/powerbi/ to be the first to tweet the news.
So by using the RSS feed as an XML table in Power Query – I was able to create a power pivot model and visualize it with Power View in Excel.
Here is what I discovered about the latest 25 blog posts from the Power BI team.
- Expect the blog post to turn up at 16:00 GMT
- Don’t expect a blog post on a Friday – there is a much better change on a Tuesday or Wednesday
- Expect the update to Power Query to be at the end of the month J
You can download the model here – and make let’s keep our fingers crossed for yet an update to Power Query – hopefully arriving at 16:00 GMT today – J