Power BI vs. Power BI Preview: What’s the Difference?

Power BI Preview is the upcoming version of Power BI. Power BI is the current “production” version of Power BI that lives within Office 365. How do they compare? Here are some of the key differences.

Power BI is Production, Power BI Preview is Preview

The current Power BI service is considered production quality, is managed by Microsoft under the Office 365 SLA and is reasonably stable as a product.

Power BI Preview is just that – it’s still in preview. It’s clearly not a complete product yet and should be viewed as Beta. There are clearly some pieces in the service that are not quite ready for prime time and the product is evolving rapidly as Microsoft adds more functionality.

Power BI is based on Excel and SharePoint, Power BI Preview is New Technology

Power BI comes from a longer history of Excel and SharePoint. Power BI is the Office 365 extension of Power View which is a technology built into Excel 2013 that allows you to create interactive dashboards based on Power Pivot models. SharePoint 2013 on premise and Office 365 support Excel Services which allows you to host an Excel file as a web page without the need for the Excel client.

The new Power BI Preview is built from newer technologies and while it can ingest Excel files and Power View / Power Pivot models, it isn’t based on them. It has its own model and visualization technologies that can leverage data from a number of other data sources and provide a different user experience.

Power BI Preview is also only cloud based where Power BI has a similar feature set with SharePoint 2013 on premise (Power BI has some features that are only available on the cloud).

Power BI Requires Office 365 and Excel 2013, Power BI Preview is Standalone

One of the key differences between Power BI and Power BI Preview is that Power BI Preview does not depend on Office 365 or Excel 2013 either for authoring or viewing. Power BI Preview has been designed in a similar way to the Office Online experience in that you can access Power BI Preview through its own URL and you can start working with the tool.

Power BI Preview Has New Data Sources

Power BI data sources are based on Power Query and Power Pivot and include traditional data sources such as Oracle, SQL Server, Azure SQL, Excel Files, CSV Files, etc. Available data sources were managed by Microsoft as part of the product.

With Power BI Preview, there have been a number of additional data sources announced already with additional data sources expected including:

  • Git Hub
  • Google Analytics
  • Marketo
  • Zen desk
  • Send Grid
  • Azure Stream Analytics
  • Visual Studio Online

In addition, Microsoft has built APIs for developing third party data connectors that will presumably allow many more data sources to be feeding into Power BI Preview in the future. They have for example just announced a new Office 365 administration content pack that will push data into Power BI Preview in the future.

Power BI is A Disconnected Experience, Power BI Preview is Semi-Disconnected

Power BI is based on Excel’s Power Pivot and Power Query engines, which create local caches of data when they pull data from their data sources. This is what creates the performance by loading up a bunch of rows into memory and caching them locally. When you refresh a power pivot table, the entire table is refreshed from the underlying data source which depending on the size of your table can take a considerable amount of time. In Office 365, you can configure your Excel sheet to use a data source that can be periodically refreshed but it’s the same basic technology.

Power BI Preview is semi-disconnected in that there certain data sources that are “live”, namely the connector to SQL Server SQL Analysis Services. In addition, the Power BI Preview architecture allows you to push data into tables incrementally instead of having the entire table refreshing. This is fundamentally more interesting, in particular for scenarios where there are streaming analytics coming in that need to be visualized.

It’s not altogether clear whether Power BI Preview will support other “live” data source connections in the future.

Power BI Preview has Additional Visualizations

Power BI Preview comes with some additional visualizations including:

Combo Chart

clip_image002

Gauge

clip_image004

Tree Map

clip_image006

Filled Map

clip_image008

Funnel Chart

clip_image010

Power BI Preview Has an IPhone App, with Android and Windows Phone Coming Soon

Power BI had a Windows 8 app but limited support for phones. Power BI Preview already has an IPhone App available with Android and Windows Phone coming soon.

clip_image011clip_image012

Power BI Is Not Responsive, Power BI Preview Is Not Responsive

One of the glaring omissions that Microsoft still continues to make is lack of support for mobile web and responsive design. Power BI is definitely not responsive, and the dashboards created by Excel are locked width and height and they sit in a non-responsive SharePoint portal.

Power BI Preview so far isn’t responsive either. Power BI Preview does however have an IPhone App available which works reasonably well.

Power BI Preview has a REST API

One of the intriguing new developments with Power BI Preview is the new REST API. You can use it to push just about any data you want into the Power BI service using basic JSON. You can create tables, add rows, etc. The API is missing some key functionality at the moment (for example, you cannot delete a dataset through the API) but the potential is huge for custom applications needing to push data into the service.

Power BI Preview Now Has Alerts, Annotations and Favorites

Power BI Preview has alerts which allow you to be notified when data changes, exceeds a threshold or exceeds a target.

clip_image013

Power BI Preview also supports annotations which work quite nicely in the IPhone App. You can add drawing lines and text to your dashboard before mailing them out to your colleagues.

clip_image015

Power BI Preview also supports the concept of favorites where you can tag dashboards, KPIs and data to your personal favorites dashboard.

clip_image016

Power BI Preview Pricing is Cheaper than Power BI Pricing

Power BI pricing started out as a separate subscription with different subscription levels. This quickly became an add-on price for those customers with E3 or E4 Office 365 subscription because of the overlap between Power BI and the features in E3 and E4. For $20 / month, you can have Power BI tacked on to your month E3 or E4 subscription.

Power BI Preview has a free version, similar to Office online. If you want to try out the service or use it to visualize a single dashboard, you can start using it immediately. However, there are limitations on throughput for the free version and there is no support for live connectivity or on premise integration with your data sources.

Power BI Preview is priced at $9.99 / user / month which is about 50% cheaper than Power BI.  The pricing is independent of Office 365 – you no longer need an Office 365 subscription to obtain this pricing. 

Microsoft has imposed some caps for that price including:

  • Data capacity limit of 10 GB
  • Scheduled data refresh of 1 hour
  • Streaming capability limit of 1 million rows per hour

It’s not currently clear what happens if you exceed these limits or whether this is even an option, e.g. do you pay additional fees if you exceed the quota or does the service simply stop you from exceeding the limits?

  • James Phillips

    Great post. Let’s call these Power BI 1.0 and Power BI 2.0. A few things worth noting:

    1. In Power BI 2.0 there will increasingly be live connections to data – as you note SQL Server AS supports direct connections (without caching the data in the Power BI service). This week we will add direct connections to SQL Azure. We demoed direct connections to the new Azure SQL Data Warehouse at our Ignite Conference. You’ll soon see direct connections to Hadoop/Spark SQL
    2. Soon you’ll also have the ability to upload ACTUAL Excel files and view them in Power BI 2.0 just like you did in Power BI 1.0. At that point, Power BI 2.0 will be a superset of Power BI 1.0 – offering all the old capabilities (upload an Excel file with an embedded data model) AND all the new capabilities – REST ingestion of data, direct connection to sources, all the new Power BI content packs from various software/SaaS companies.
    thanks for writing about Power BI!

    James Phillips
    Microsoft Power BI

  • Pingback: Power BI vs. Power BI Preview: What’s the...()

  • duicie

    any reason that with Power BI Preview, that I cant share my dashboards to people outside my “organisation” – aka with the same email extension… considering I am sending it to people inside my organisation… who just have a different name after the @ symbol? doesnt look like it is fully disconnected from the Office 365 model as yet….unless I am missing something? many people seem to have blogged on the power bi forum in regards to this fatal flaw…