Microsoft Launches Self-Service BI
Written by Kay Ewbank   
Wednesday, 19 February 2014

Power BI for Office 365, Microsoft’s self-service business intelligence solution designed “for everyone” is now generally available.

Power BI, which we first encountered when it was demoed at the Microsoft Pertner Conference in July 2013,  is aimed at business users, and offers the ability to create BI models based on data from Windows Azure and other sources.

Users get a public and corporate catalog of data sets and BI models, along with search mechanisms, ways to collaborate, strong graphing options, and support for natural language queries.

This two-minute promo video gives you a quick overview:




One in four of Microsoft’s enterprise customers now has Office 365, making this a large potential market for the new product. While the system is aimed at business users, its adoption would create many opportunities for developers creating the underlying data and BI models (and making the queries work when the business users admit defeat).

Power BI for Office 365 is being offered at the promotional price of $20 per user/month to new or existing Office 365 Enterprise E3 or E4 customers. A free 30-day trial is also available.

Discussing the new product on the Official Microsoft Blog, Quentin Clark, Corporate Vice President, Data Platform Group, says:

“In my role as head of our data platform group, I don’t create a lot of models, but I consume a lot of them.”

He points out that currently intelligence is only used by a fraction of the people that could derive value from it, saying

“What we all need is modernized business intelligence which will help everyone get the information they need to understand their job or personal life better.”

On the its blog, the Power BI team said that the new cloud-based environment lets business users create collaborative BI sites. Reports can be kept up to date with scheduled data refresh, and teams can share not only Excel workbooks but also the data queries created in Power Query for Excel. Mobile access to reports is provided via HTML5 support and a Power BI windows app.

The line up of tools and technologies in Power BI for Office 365 includes:

  • Power Query
  • Power Pivot
  • Power View Power Map
  • Power BI sites
  • Data Management
  • Power BI Admin center
  • Power BI for mobile
  • Power BI Q&A


This hour-long demonstration shows how they all work together:



The Q&A features looks like one of the more interesting additions. Users can type the questions they want to know the answers to about the data using natural language and the system will interpret the question and present answers in the form of interactive visualizations.


More Information

Power BI for Office 365

Official Microsoft Blog

Power BI Blog

Related Articles

Power BI

Microsoft Excel 2013: Building Data Models With PowerPivot (Book review)

Business Intelligence in Microsoft SharePoint 2013 (Book Review)

Pro SQL Server 2012 BI Solutions  (Book Review)

European Office 365 Connect 2014


To be informed about new articles on I Programmer, install the I Programmer Toolbar, subscribe to the RSS feed, follow us on, Twitter, Facebook, Google+ or Linkedin,  or sign up for our weekly newsletter.


C book



or email your comment to:



Developers Like Code Assistants Even When They Are Incorrect

Over half of ChatGPT answers to programming questions contain misinformation, yet the majority of developers are still keen to use AI tools and report both personal satisfaction and increased producti [ ... ]

Kotlin 2 Released With Multiplatform K2 Compiler

Kotlin 2.0 has been released. The new version is a major update with improvements including a stable K2 compiler, which is multiplatform from the ground up, and according to JetBrains understands your [ ... ]

More News

Last Updated ( Wednesday, 19 February 2014 )