Dynamic IP and Reserved IP in Azure Virtual Networking

By Satalyst Brilliance on 24 Jul 2015

Convert Existing Dynamic VIP to Reserved IP Addresses in Azure

Some of the best changes to Azure announced at Microsoft's Build Developers' Conference this year that didn’t get a lot of attention were the change to Azure Virtual Networking.

By default, when you create Azure cloud services they are allocated a Virtual IP (VIP). This IP address is dynamic in nature and will change when the cloud services are de-allocated or the underlying Azure infrastructure moved your service due to underlying hardware issues.

Read More

Power BI vs Datazen

By Satalyst Brilliance on 20 Jul 2015

As you may have heard, Microsoft acquired Datazen in April 2015 to boost their BI dashboarding and mobility offering. This announcement has left a lot of people confused - where does Datazen fit in the Microsoft BI roadmap? Does Datazen compete with Power BI? Complement Power BI?

Read More

Power Query: Creating a parameterized function in M

By Satalyst Brilliance on 19 May 2015

This will be part two in my on-going series about Power BI, Power Query, and the general joys of data. In my last post I outlined how to iterate over a list in Power Query. But what if I want to iterate over a list and need to parameterize it with today’s date? What if I want to issue multiple web requests based on a list? This is exactly the scenario I had when trying to fetch crime data from the WA Police web site. First, I have to thank my colleague and web wizard John Chillemi who authored the azure website that I’m using. The WA Police site has all the data, but not in a nice HTML table, which is what Power Query needs. So, thanks to John, I can execute a single web request and get a webpage that looks like this:   The web request takes five parameters – Suburb, Start Month, Start Year, End Month, and End Year, as seen below: I’d like to execute that web request for every suburb in Western Australia (there are over 1300 by my count) so obviously this is a case for automation, which means I need an M parameterized…

Read More