Large SAP BW installations with thousands of users are often accessed via single-sign-on (SSO) e.g. the users windows credentials are used to authenticate to BW. SSO simplifies the user experience and reduces user administration costs. These users should be able to setup on-premise gateway connections that can be used to refresh data sets in the Power BI Service. The connections should leverage that individuals BW roles & authorizations and not require a BW password i.e. automatically associate the Power BI user ID to the associated SAP user ID.
As Power BI competes with the SAP Self Service Solution Lumira, which offers full BW Support, connectivity should be a top priority.
Many Small/Mid Companies use BW without BO and SAP is pushing Lumira intensively.
SAP BW will be a huge success!
Connector for SAP BW would be nice.
SAP BW and SAP ECC/R3 is a must
SAP HANA would be a great source...
In my mind the SAP Netweaver Gateway would be a good choice for all. The Gateway should be available for everyone with a Business contract automatically. On the other hand the GW is the promoted Connectivity method of the future in order to connect to non SAP Systems. All BAPI and RFC related Objects in ERP, BW and other Netweaver based products will be available via ODATA. So OATA in combination with Netweaver Gateway would be my choice.
Connectivity to SAP BW could be a game changer for Power BI. SAP tools for querying the data are not very user friendly. If Excel and/or Power BI Designer had SAP BW as a data connector (not the BO Universe connector), this would make life so much easier for end-users who would no longer have to wait on their IT department to do everything for them. Tableau has it, Power BI needs it!
ERP connectivity then BW then HANA. All of my customers run SAP, this would really help drive adoption of PowerBI for our enterprise customers.
I made a suggestion yesterday for "What should be build next" but it does not seem to work today, Anyway, I am happy to retype it for a good cause.
40% of US EPG customers run SAP and over 50% of US EPG customers are SAP customers. A typical SAP customer will have a very mature BW implementation that is used company wide for reporting (BW stands for Business Warehouse). Hundreds of thousands if not millions of users are using the SAP technology called BEX to extract data from BW into excel and then use HLOOKUPS, VLOOKUPS and SUMIFs to build reports in Excel / PowerPoint. There is never a sales cycle with and SAP customer where this does not come up and today we have no answer for BW connectivity. This is hugely important.
ability to connect directly to SAP is somewhat interesting too, however, it is a level of magnitude less common.
Currently, it is uncommon for IT departments to enable self service access for end users to HANA, therefore I think this is the least important. It's a nice have, but since Hana is a direct compete with SQL Server, I would prioritize it last.