April 25, 2017
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
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Hi Scotty,
You have the microsoft instructions for SAP here:
https://learn.microsoft.com/en.....a/overview
You will have to install from SAP support center the SAP HANA ODBC driver they provide.
1 Guest(s)