Soooooo…you now have two approaches to hosting BI in the cloud (Power BI vs. Azure VM Role for BI Deployment)

With the announcement of Power BI at the WPC last week, Microsoft now has *two* ways it can host your BI application in a public-cloud setting.  Power BI delivers self-service BI modeling, transformation, reporting, and geospatial via Office 365. Of course, you can run both the traditional (SQL/SSAS/SSRS/SSIS) and self-service (Power Pivot/Power View) by provisioning…


Power Query – Pulling in Foursquare Data into Power BI

As a follow-up to my previous post, I wanted to do a quick demo of how to pull in JSON-structured data into Power BI.  Going directly into Power Pivot isn’t an option; we need to use Power Query to help pluck the data we need out of the API call.   In my example, I…