I have a question on the art of the possible. I am a novice user with Power Query. We have an SAP ERP system and use tools like SAP Analysis for Excel to extract data from SAP BW. I would like to be able to connect to, and extract data from, SAP ERP using Power Query. I only have Power Query and not Power BI, which might have more capabilities.
I'm sure the setup of every SAP ERP system, but are there some generic instructions out there on how to do this? Like connect to your XYZ server for your organization? That capability would be helpful vs. going into ERP itself.
Thanks in advance.
-Scotty81
Hi Scotty,
You have the microsoft instructions for SAP here:
https://learn.microsoft.com/en-us/power-query/connectors/sap-hana/overview
You will have to install from SAP support center the SAP HANA ODBC driver they provide.
Hi Catalin,
I will definitely check this out. Thanks for the link.
Regards,
Scotty
Hi Scott,
I had same challenge, fixed it this week via freeware tool ExtracTable for SAP. Has also a webservice that i Connect it to so that it refreshes real time table data from SAP.
check if you like: https://sourceforge.net/projects/extract-table-for-sap/
i just could not get the SAP HANA ODBC connector interfaced with our SAP application server, i guess it needs direct hana db access. The ExtracTable tooling flows via the app server and is read only which our SAP administrator required.
cheers, Don
