Summary: Microsoft’s Power BI Team Does an AMA

One June 10, the Power BI team at Microsoft conducted an Ask Me Anything (AMA) on Reddit, and there were some standard non-responses, but there were also some interesting insights into what the team is thinking about the product and the direction it is planned to be taking.

Here is a quick summary of the items discussed:

Power BI in Office 365 Home

As you may know, Power BI is only supported with Office 365, and only with certain higher-end editions of the service. Many customers and potential customers who have interest in analytics and business intelligence but simply cannot afford a higher-end Office 365 edition. So the question about being able to access Power BI in a Home edition is legit, and I am glad the team responded to it and the good news is that it is a highly-requested feature, and we may see something on that soon. From the answer here:

Customers have asked for some subset of Power BI functionality be available in other versions of Office and it is something we actively discuss. We are hoping to have great news in the coming months. (Carl Perry, PM)

Power BI On-Premises

Power BI currently only works with Office 365 and SharePoint Online. One of the reasons is that with cloud-based services, Microsoft is able to release quickly and release often. Hence, the response here is that it won’t happen at least until the next version of SharePoint is released. From the answer here:

For Power BI on-prem, the earliest you’ll see this is in the next major release of SharePoint. (As of today we don’t have dates to share/discuss for this release.) We’re taking advantage of the capabilities of Office 365 cloud services to release early and often in Power BI, but on-prem SharePoint is releasing on a more traditional on-prem schedule. [Matthew – Data Catalog PM]

Duplication of languages/interfaces

Microsoft now has several ways of doing the same thing, across client and server. For example, in Power Query they are using the “M” language to transform and shape data, whereas their SQL Server Integration Services, their Extract/Transform/Load tool has its own expression language. They are aware of this, which is a good thing, but there will always be overlap in functionality across their tools. Similarly, Power Query and Power Pivot offering similar ways to manipulate data. From one response here:

We are working hard on making sure we remove as much overlap as possible in the UI, for example we want to have a single place to import data in future updates of the product. The overlap between M and DAX is a very interesting as in nature they serve very different purposes. DAX is very analytical in nature, meaning optimized for business problems / aggregations. M is optimized is a functional language optimized for data transformations. I agree there is some overlap between DAX calc. columns and M and we are thinking about optimizing the overlap here. (K de Jonge, AS team)

Another response here:

We are definitely working on our relationship, as with any marriage it’s a lot of hard work. No, seriously, you will some of the more annoying issues fixed in the current version of Office and we are looking into how to optimize our two products for future versions. (K de Jonge, SSAS team)

We’re actively working on improvements in Power Query that will address the most common causes of this type of “destructive change” problem. We release a new version of Power Query each month, so be sure to stay up to date. [Matthew – Data Catalog PM]

And another one here:

Although both “M” and SSIS expressions are tools for manipulating data, the contexts in which they operate are different enough that it’s pretty unlikely that M will replace SSIS expressions.

But with this said, we are actively looking at ways to make Power Query and SSIS play better together. Prior to Power BI GA we separated the Power Query engine (the part that executes queries) from the Power Query add-in UX, and are looking at a variety of scenarios where that engine can be hosted in different processes. SSIS is an obvious one. [Matthew – Data Catalog PM]

Power BI for Android

This was bound to come up, and per Microsoft the fact at the moment is that Android has tremendous reach in consumer space, but not much in the enterprise. As a result, the focus has been on Windows and iOS. From their response here:

We decided to initially focus on Windows and iOS first. Android does have a big market share in the consumer space but its growth in the enterprise was less initially. We are actively monitoring the trends and Android support is definitely on our roadmap. (Cindy S. – Mobile BI PM)

Power BI with Dynamics? Maybe a Salesforce connector hint?

While Power Query can pull from a variety of data sources, there is no connector to Dynamics CRM. Power BI officials said that they have friends in Dynamics team and something should happen soon. At the same time they seem to hint that something else in the CRM space may happen soon too. Could that be a hint that a connector is coming soon, given the recently announced partnership between the two companies? See here:

We have some really good friends in the Dynamics team and are pushing to make getting that data in to Power BI as seamless as possible – And, as we generally like to make new friends, we’re working on some new CRM capability provider friendships as well.


Feedback for Power BI is being collected via Connect, and it goes straight to the team’s Visual Studio Team Server. They use the votes up/down as a factor to prioritize the backlog of features. See here:

Challenge accepted: And as proof yo:

Connect items go straight into our VSTS instance so they really do get looked at! We track the up/down votes and that goes into our planning cycles. You can also give feedback through the product now! There are links and smiley faces in the products that you can use to give us feedback. Also:

(Will T – British Power View PM)

Third party visualizations

On the topic of allowing third party visualizations, Microsoft said that they are focused right now on getting the HTML5 version to be on parity with the Silverlight version. Once that happens, they plan to add many more visualizations and maybe even open it up to third parties. That’s promising! See here:

Currently the Power BI team is working on bringing the new HTML5 version to parity with Silverlight with respect to visuals and also adding some new important visuals. We will then be adding lots of new visuals and during that process, we will take a look and see how to open up the platform to third party custom visualizations.. Stay tuned! [Ajay, Power View PM]

It is very easy to duck questions in an AMA, especially when it is product roadmap type of questions. I think the Power BI team did a good job of taking the important questions, and responding fairly openly. I am most interested in the addition of Power BI in Home edition. What about you?

Here is a video talking about Power BI for Office 365: