Last week at its 2014 SharePoint Conference, Microsoft announced Power BI connectivity to SAP BusinessObjects BI, described as “a joint business intelligence interoperability solution delivered with SAP”. The solution allows users to query UNX universes from the Information Design Tool from Microsoft Excel 2013. Andrew Fox has an excellent write-up of his first-time experience on his blog (see related article, Microsoft Power Query Connectivity to SAP BusinessObjects Universes – How to get started). But Andrew doesn’t feel that PowerQuery has sufficient capabilities to retire Live Office. At least not yet.
— Microsoft BI (@MicrosoftBI) March 3, 2014
It’s certainly an interesting development, as Live Office 4.0 did not receive any significant updates. Its inability to query new UNX universes from the Information Design Tool is a curious omission. My co-worker Ahmed Sherrif thinks Live Office is as good as dead (see related article on the EV Technologies blog, Live Office is Dead to Me). Looking for answers, I posted a question to Twitter that’s probably on the minds of a lot of SAP BusinessObjects Live Office users.
— Dallas Marks (@DallasMarks) March 3, 2014
There’s been no official word from SAP on the release of Microsoft PowerQuery.
— Dallas Marks (@DallasMarks) March 5, 2014
So we don’t know if it is the official successor to SAP BusinessObjects Live Office. There had previously been some rumblings from SAP that Live Office functionality would be migrated to SAP BusinessObjects Analysis for Microsoft Office. The lack of official news from SAP confirms my suspicion that nobody ever got promoted for being Live Office product manager.
@DallasMarks Nearly snorted my coffee out my nose reading this.
— Noël Hollis (@DatabaseFairy) March 4, 2014
Microsoft Excel is the most popular BI tool. Getting data from Excel into SAP Lumira and Web Intelligence is a key capability. But some users prefer to do the opposite- get data into Excel and other Microsoft Office applications. In any case, there’s a SAP business intelligence product that is trapped between the living and the dead. With the North American SAP SAPPHIRE still two months away, let’s hope that more details about Microsoft PowerQuery and SAP BusinessObjects Live Office emerge before then.
- Microsoft Adds Connectivity for SAP BusinessObjects to Power BI for Office 365 via MSDN
- Microsoft Power Query Connectivity to SAP BusinessObjects Universes – How to get started via Andrew Fox or on SAP Community Network with interesting comments
- SAP BusinessObjects Live Office 4.1 on the SAP Help Portal
- Live Office is Dead to Me by Ahmed Sherif
- Follow Microsoft BI on Twitter
- Follow #PowerBI conversation on Twitter