I’ve been doing a bit of work for a global company who are SAP based. They use the BW solution and they are moving to the SAP HANA database solution (In memory database, swish!), however they have recently moved from Lotus Notes (blah!) to Office 365 (nice!) so they have a foot in both SAP and Microsoft worlds, and wanted to compare Power BI and SAP Lumira for their self-service business intelligence needs. So what did we find out? And can SAP HANA & Power BI play nicely together?
Connecting Power BI
The SAP Universe connector that was in the Power BI Desktop Preview is sadly not available any more in the release in July, and only lingers on in the Power Query connections in Excel 2013. Word on the street is that SAP poo-pooed the idea of a connector, as they didn’t want Microsoft having a better BI front end that SAP Lumira and their cloud offering had. Fetch the rolled up newspaper, bad SAP [Slap], naughty! So we are
left with two options ODBC and OData to connect to a Calculated View. For those not familiar with SAP (myself included), its like a OLAP cube, with aggregations, but flatter with dimensions and measures mixed together. (Please correct me in comments if needed). Normally I would extract the data to a source that Power BI can use like SQL Server or Azure, but not in this case, connect to SAP HANA or nothing!
In trying to connect Power BI I came across a few limitations.
4: For ODBC connections Calculated Views do not show up in the browser list of objects. You have to use an SQL query to get the data into Power BI.
http://hanaserver.somevendor.com:8000/Power_BI_PoC/PowerBIODataV1.xsodata/Results?$filter Region eq ‘Europe’One of the other things with OData connections is that you add in the OData connection set up the SAP HANA column names, and it will bring through the column labels fine in the OData XML and then on to Power BI
ODBC connections and the resulting query is a lot faster than OData to get data from SAP HANA. Power BI took a few minutes for the OData, and seconds for the same volume in ODBC. I assume, that as its reading the data, putting it into JSON format, then Power BI transfers it back to a table format, its going to suck up some processing time.
IMHO, SAP have made a strategic mistake in not allowing a SAP connector to Power BI, it is old world thinking to limit the SAP application in such a way so they can sell SAP Lumira on top of their SAP DB’s. I’ve experienced first hand and the industry is moving to a place were customers want their technology to talk to each other, Power BI has connectors to Oracle, Teradata, Salesforce and so many more, sure it works great with the Microsoft stack of databases, both on premise and cloud, but its not limited to it. Customers want less tools and applications, training time is expensive both in cost and time for the person to be out of the business and they have already invested in capital for their IT systems. SAP Lumira having seen it, it can’t compare to Power BI in terms of usability and visualisations, and the rate that Power BI is moving with updates and capability, SAP Lumira isn’t going to catch up, so please SAP do yourself a favor, work with Microsoft get a connector sorted, welcome to the new world, it’s glittery and interconnected.