Forum Discussion
How get data directly from SAP ECC
Since the last question someone asked about that was 2 years ago. I wanna know if its possible to get data direclty from the SAP. I am pretty sure that my SAP is ECC, and I wanna know how I can pull...
Do you need to install sap gui to use the extract table?
I've been trying for months, and when it connects what should be done to achieve the connection to extract
For the sourceforge ExtracTable tool to download or live connect SAP tables to Power BI or Power Query the SAP GUI is not needed.
Use the tool's 'extract_table web service' in the power BI Web data source for real-time data retrieval. You need then to configure BI a little to get the streamed XML table presented the best.
For none real-time data (e.g. downloaded via the tool at night or so) you can just link Power BI to the corresponding saved CSV or Excel file.