Chris Webb's BI Blog

Analysis Services, MDX, PowerPivot, DAX and anything BI-related

Office 2013, Office 365 Editions and BI Features

with 32 comments

By now you’re probably aware that Office 2013 is in the process of being officially released, and that Office 365 is a very hot topic. You’ve probably also read lots of blog posts by me and other writers talking about the cool new BI functionality in Office 2013 and Office 365. But which editions of Office 2013 and Office 365 include the BI functionality, and how does Office 365 match up to plain old non-subscription Office 2013 for BI? It’s surprisingly hard to find out the answers…

For regular, non-subscription, Office 2013 on the desktop you need Office Professional Plus to use the PowerPivot addin or to use Power View in Excel. However there’s an important distinction to make: the xVelocity engine is now natively integrated into Excel 2013, and this functionality is called the Excel Data Model and is available in all desktop editions of Excel. You only need the PowerPivot addin, and therefore Professional Plus, if you want to use the PowerPivot Window to modify and extend your model (for example by adding calculated columns or KPIs). So even if you’re not using Professional Plus you can still do some quite impressive BI stuff with PivotTables etc. On the server, the only edition of Sharepoint 2013 that has any BI functionality is Enterprise Edition; there’s no BI functionality in Foundation or Standard Editions.

[For those of you thinking of upgrading from Excel 2010 PowerPivot to Office 2013, Marco has all the details on compatibility of PowerPivot workbooks across different versions here.]

Office RT, which runs on Windows RT, has several limitations on its BI functionality: there’s no PowerPivot, Power View or Excel Data Model. Luckily, Kasper has summarised what it does do in a blog post here, so I won’t repeat what he says.

Moving on to 2013 functionality in Office 365, and specifically BI in Sharepoint Online, things get more complicated. Although feature support information for Office 365 is on Technet here, the best place to start is Andrew Connell’s blog post and corresponding feature matrix that is viewable through (appropriately enough) the Excel Web App. The feature matrix makes it very easy to filter Office 365 features by workload so you only see the BI-related ones:

image

image

As you can see, the short answer is that you need either Office 365 E3 or E4, or SharePoint Online Plan 2 to get BI functionality. The Office Professional PlusE3 and E4 plans are also the only plans to include subscriptions to the desktop versions of Office Professional Plus, and they allow it to be installed on up to 5 machines per user. The other thing you’ll notice is that PerformancePoint is not available at all in Office 365 (read into that what you will); it is of course available in Sharepoint 2013 Enterprise Edition on-premises.

There are other functionality differences between Sharepoint Online in Office 365 and on-premises Sharepoint too. The details are here, but the important ones are:

  • At least for the moment, Excel workbooks can be no larger than 10MB
  • The Excel Data Model will only refresh successfully if it sources data from the workbook itself; no external data sources are supported (though again I’d be surprised if that restriction isn’t lifted in the future)
  • There is no PowerPivot for Sharepoint functionality such as the Gallery, usage reporting or scheduled data refresh.

These are quite significant restrictions, it’s true, but if you are a purely self-service BI shop and you just want to use Sharepoint Online to publish PivotTable or Power View reports that don’t need to be refreshed (or can be refreshed manually on the desktop and then uploaded) then this functionality should be sufficient. This is the kind of scenario I showed here, and I think a lot of customers with no existing BI will still be impressed with it; obviously it’s a problem if you want to do any kind of corporate BI.

BUT. At the time of writing the Enterprise plans for Office 365 haven’t been fully updated for Office 2013 functionality, so all this BI functionality isn’t actually available yet to most subscribers. This means that the desktop versions of Office you can download are still 2010 and not 2013; online, while you can get the latest Sharepoint features if you’re part of the Office 365 Preview, if you’re currently an Office 365 subscriber you’re probably still on Sharepoint 2010. The official line on when the upgrade to 2013 functionality will take place is a bit vague – it will take place “in the course of 2013” – and there seem to be a few upset customers out there (see here for example). February 27th seems to be a significant date.

Finally, apart from Office 365 it’s also possible to view Excel workbooks via SkyDrive. However pretty much no BI functionality is available when you do this: no Excel Data Model, no external connections, no Power View, just the ability to view (and not alter) PivotTables. These restrictions seem to be more or less the same if you use just the Office Web Apps server on-premises without Sharepoint 2013 – see the relevant table here for details.

In summary: my head hurts! All these editions and licences… it would be nice if it was less complicated.

UPDATE: some new information, and some clarifications, since I first wrote this post

1) Office Professional Plus 2013 will be available via Office 365 on February 27th 2013. The cheapest subscription option that includes Excel on the desktop with PowerPivot and Power View is, as far as I can see, this one, an Office Professional Plus subscription, that is included in the E3 and E4 plans.

2) Office Professional Plus is only available via Open, Select or EA licensing (see http://www.microsoft.com/en-gb/licensing/default.aspx for more details on what these options are). Excel 2013 standalone is only available via Open or Select. This means that no regular retail editions of Excel include PowerPivot or Power View, you can only get them through a Volume Licence Agreement or Office 365 (ie you need to be working for a big company with deep pockets unless you buy yourself an Office Professional Plus, E3 or E4 Office 365 subscription); compare this with PowerPivot for Excel 2010 worked with any edition of Excel. Existing PowerPivot users are not particularly happy about this when they find out: see here and here for example. Is this a good strategy? Hmm…

3) Right now, I’m told there is a problem with how the addins are packaged with Excel 2013 standalone which will be addressed in a future update.

UPDATE  2: I’ve just found out that standalone Power View is not supported at all in Sharepoint Online/Office 365. Only Power View sheets inside Excel workbooks are supported.

UPDATE 3: Power Pivot is now available in standalone versions of Excel too as of August 2013 – http://www.powerpivotblog.nl/power-pivot-and-power-view-now-available-in-excel-stand-alone

UPDATE 4: This blog does not cover the BI features that are available in Power BI. A Power BI subscription is an add-on to an Office 365 subscription and gives you extra functionality. You can find out about the licensing here and I’ve blogged about what it gives you here, here and here.

Written by Chris Webb

February 1, 2013 at 8:04 am

Posted in BI, Office 2013, Office 365

32 Responses

Subscribe to comments with RSS.

  1. Excel 2013 based BI sounds way to confusing and restricted. It will be a nightmare for businesses to navigate a purchase.

    Seems like the competition (Qlikview, Tableau, Spotfire etc.) are evolving quickly, but Microsoft is it’s own worst enemy.

    Steve

    February 1, 2013 at 9:07 am

  2. [...] Office 2013, Office 365 Editions and BI Features by Chris Webb. [...]

  3. Chris, your post about BISM a while ago made me feel it was OK to be confused and this post falls into the same category. But again thank you for the enlightenment.

    Philip Taylor

    February 3, 2013 at 10:36 pm

  4. [...] la lecture d’un article de Chris Webb sur les fonctionnalités Bi incluses dans la version On line de Sharepoint 2013, je me suis lancé, avec une certaine dose de septiscisme, dans la configuration  des services [...]

  5. The full Powerpivot only for large companies haven VL deals? And I thought this is about BI for the masses? I work in a small company and spend the last two years learning dax. Powerpivot is the only reason we still have a few office Licences, the rest is using Openoffice.

    The Powerpivot Windows helped me a lot at the beginning, instead of loading data in Excel tables via MsQuery and then using excel functions to transform them, I used the Powerpivotwindow to do the same, beeing able to use almost the same functions. I do things differently now, having increased my SQL knowledge a bit and my DAX knowledge a lot, but at the beginning this was really important.

    Carsten B.

    February 11, 2013 at 9:54 am

  6. Thanks for trying to provide some clarity. I’m really getting a bit tired of the ever growing complexity that Microsoft keeps adding to their products, particularly the cloud services. Way TOO MANY plans and options and addons. We really need things more SIMPLE not complicated. Oy.

    MikeH

    February 12, 2013 at 2:00 am

  7. [...] handsome Jeff Weir points us to this article from Chris Webb’s BI Blog explaining the entire [...]

  8. Not too confusing. Microsoft’s competitors must be thrilled.

    SF

    February 15, 2013 at 2:28 pm

    • Yes…I agree. I purchased Office 2013 Home and Business. Microsoft Support actually spent over 12 hours “working” on a solution to determine why I don’t have Power View and finally directed me to this site.

      I am ticked.

      Does anyone know if Microsoft will give you full credit for your purchase of the Home and Business Version and allow you to apply that towards the Professional or Enterprise Version.

      Failing that….I would be very interested in hearing what the competition has to offer.

      LWF

      Larry

      February 20, 2013 at 3:01 am

  9. [...] release date for Excel 2013 gets nearer (in fact Home Premium has already arrived) the pricing and package offering are becoming clear(er). For many of us the emerging picture is not pretty, mainly due to a u-turn on Microsoft’s [...]

  10. They seem to have learned a lesson with OS Licensing, but the Office team led by some old beards still unwilling to succumb. They will die fighting for more and more complicated licensing. The Cloud (free and paid), subscription licensing, and other added another dimension to the already complicated maze.

    Sreekumar

    February 19, 2013 at 6:23 am

  11. [...] Chris Web: “Office 2013, Office 365 Editions and BI Features“ [...]

  12. Tableau has a model Microsoft could do well to copy. They built a product which is amazingly rich, but so simple.

    Then they coupled it with the simplest pricing on the market. It costs $2000 per user. If you have more users, multiply the number of users by $2000, pay an extra 20% in year two and beyond if you want support and future releases.

    If you don’t want to pay, use the free edition, tableau public.

    There are no modules, no volume discounts, just pay for a license and get started.

    That’s the way to do it msft! Oh, and include a major new release every six months too.

    trwb99

    February 19, 2013 at 7:30 pm

  13. [...] can be further broken down (see Chris Webb’s blog on Office 365 options here), but to keep this easy to follow, I’ve kept it to key comparable [...]

  14. Hi Chris,

    I have a question. We are starting an Office 365 E3 edition deployment and I am not clear on whether or not we will be able to connect to our on-premise cubes etc. with the Sharepoint version we have in the cloud or if we will only be able to push reports and pivot tables to the Sharepoint in the cloud site.

    Fundamentally trying to determine whether or not we need to have a hybrid sharepoint environment to support both our interactive power users with deep drillthroughs and linkages and our field organization that is okay with just having a report posted to the cloud site.

    Thanks and see you at PASS 2013!
    ken

    Ken

    March 9, 2013 at 12:05 am

    • Hi Ken,

      I’m 99% certain you can-t connect to your on-prem cubes from Excel Services/Sharepoint in Office 365. The 1% of doubt is because I haven’t properly checked out the new cloud AD stuff, but I’m sure I would have heard of other people doing what you want to do if it was possible. It sounds like you’ll need some on-prem Sharepoint too.

      HTH,

      Chris

      Chris Webb

      March 12, 2013 at 9:39 am

  15. You currently can’t live connect Excel in Office 365 Cloud to an on-premises data source.

    MSBI Pro

    March 24, 2013 at 10:02 pm

  16. i’m reading so many complaints from the crowd here. almost like the advice and complaints you’ll find at a football match sideline.
    if you want to go use Open Office, then go use it, be happy and If you find Tableau to have better structured plans, then why don’t you go use it at very toppy rates of 999 or 1999 for a desktop edition alone…
    i don’t know any small company that will be able to fork out that amount of money on a viz tool alone
    everyone uses excel though, and I know lots of people that uses excel with Tableau public, although they don’t like the fact that their data is now public.
    we use both MS and other tools and we always look at the best fit per client without slating any tech company, except maybe Qlikview(even though we could be busy for years redoing the loads of abandoned Qlikview implimentations, so thanks Qlikview for all the work)
    also, Tableau is a viz tool, not an integrated Office product with email and filesharing capabilties, etc, etc, etc
    I just get the feeling most people would like to complain about the party that they’ve been invited to
    if you don’t want to be at the party, then leave and go home or OpenOffice

    Pieter

    May 8, 2013 at 9:17 am

  17. […] available in either O365 E3/E4 or the standalone versions of SharePoint Online.  More on this from Chris Webb’s Blog here.  Also, Power View is vastly limited in the cloud version of SharePoint 2013 – it does not […]

  18. […] Webb’s blogpost Office 2013, Office 365 Editions and BI Features. Chris makes an elaborate grid showing the various Office and SharePoint […]

  19. […] Webb does a good job of breaking down the various SKU’s here.  He has more patience for deciphering this sort of thing than I do, so go read what he […]

  20. […] SharePoint, for 1 to 100,000 employees — all hosted in the Cloud.  But please note that only certain editions of Office 365 and SharePoint Online provide SharePoint BI functionality.  Also be aware that PerformancePoint Services is not offered in any SharePoint Online edition.  […]

  21. […] employees I’ve talked to struggle to understand which functionality is in which SKU. The long post I wrote about BI functionality in Office and Office 365 earlier this year, before Power BI came […]

  22. Hi! Do you have some tutorial about Microsoft BI for Office 365? thanks

    Stefano

    January 15, 2014 at 5:53 pm

    • I don’t know of any tutorials for Office 365 alone – what kind of topics are you interested in learning about specifically?

      Chris Webb

      January 15, 2014 at 9:16 pm

  23. Is SSRS integration now allowed in O365 E3/E4 plans?

    David Ocampo

    January 31, 2014 at 3:34 pm

  24. […] back to Power Pivot.  Chris Webb (MVP) had talked about the problem toward the bottom of this blog post.  At this point in time, the net result is that some of the Power BI Add-ins are available for […]

  25. Is there a standard way for a Powerview dashboard hosted on Office 365 can source data from a on-premise SASS Tabular cube?

    Saurabh Pali

    August 27, 2014 at 10:07 am

    • No, but Microsoft has promised to deliver this soon (though I don’t know when exactly)

      Chris Webb

      August 27, 2014 at 11:00 am


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 3,311 other followers

%d bloggers like this: