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…


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…


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…


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…


How can I check out Power BI?

If you want to check out the entire Office 365-hosted incarnation of Power BI, you can register to get in the queue for the preview now at http://office.com/powerbi.  Microsoft will start churning through the queue in about four weeks.  In the meantime, you are more than welcome to install the components you’ll need on your machine…


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…


Power BI – Why would you ever need Power Query when I already have Power Pivot?

I’ve been mulling this question over since the first incarnation of the former Data Explorer technology.  At first, I wondered if this was developed in some secret back-room in Redmond – completely outside the watching eyes of any of the “mainstream” developers. Now, I get it. The easiest way to think about Power Query vs….