Category: Power BI

The March 2014 Release of Power Query is now available to download

Microsoft has released the latest update for my favorite Power BI tool. There are several cool albeit minor improvements to the functionality. The post at the link does a great job of describing the new changes, so I am not going to rehash them here. What I do find interesting, however, is that Microsoft is

Continue reading

Power BI Data Management Gateway and OData

I just got back from the SharePoint conference and wanted to write down a few points about the Power BI Data Management Gateway before I forgot. It appears that there may be a progression in how Power Query may get used by an organization. I cannot say I am 100% clear on all the scenarios

Continue reading

HTML5 and Anonymous access in Power BI… or check out the new Demo Gallery

I don’t expect that anyone will be blown away, at least initially, with the new demo gallery now available on the Microsoft Power BI site because to a business user, the content of those demos will look a little difficult to relate to if not a little nonsensical. Zany layouts aside, there is, however, a

Continue reading

What is Power BI Gateway?

After I wrote the step by step guide on integrating on premise data with Power BI models I realized that I actually dispensed some bad advice. The basic premise of the post was to demonstrate how one may use Power Query to source data into a Power Pivot model in a very elegant way (at

Continue reading

HTML5 support In Power View and Power BI

Now that Power BI is Generally Available (GA) I thought it would be useful to do a quick analysis of how Power View visualizations are supported in Power BI across the three media – Silverlight (default), HTML5 and Windows 8 App Please find a table below for a quick reference Feature Silverlight HTML5 Windows 8

Continue reading

How to configure on premise access in Power BI and use Power Query to load on premise data into Power Pivot

In this post I will walk you through all the steps necessary to expose your on premise enterprise data to your Power BI users of Power Query in Excel and also will demonstrate how to source that data into a Power Pivot workbook. I am not going to give you too much theory, rather, I

Continue reading

Microsoft self-service BI on premise vs cloud

It appears that Satya Nadella has added an additional layer of context to the already ambitious Microsoft strategy of transforming itself into a “devices and services” company by declaring that “Going forward, it’s a mobile-first, cloud-first world”. I believe that it is safe to assume that in the near future, the roadmap of every Microsoft

Continue reading