A new release of Power Map for Excel!

Hi, folks, and thanks for checking things out here. Microsoft quietly released a new version of Power Map for Excel.  It’s still in Preview mode, but there were some notable performance and stability changes.  You may also notice some net new functions in the ribbon for Power Map (e.g. 2D Charting options). If your copy…

1

SAP Netweaver Gateway – Another Strategy for Microsoft BI + SAP Interoperability?

Hi folks – thanks as always for reading my blog.   If you are reading this article, I hope you have had a chance to read my first post on the topic.  If you haven’t, you can access it here.  It covers Microsoft’s white paper on SAP/Microsoft BI interoperability – plus some of my color…

1

Clearing up some confusion around the Power BI "Release"

Hey folks.  Thanks again for checking out my blog.   Yesterday (8/12/2013), Power BI received some attention from the press.  Here’s one of the articles that I had seen talking about the “release” of Power BI: http://www.neowin.net/news/microsoft-releases-power-bi-office-365-for-windows-8rt   Some of us inside Microsoft had to address all sorts of questions around this one.  For the…

8

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…