SAP Connection to Power Query

Resolved · Medium Priority · Version 365

Mon 31 Jan 2022, 09:28 Delegate Lionel said...

Lionel has attended:
Excel VBA Introduction course

SAP Connection to Power Query

I am having trouble connecting my SAP finance database to Excel Power Query. I couldn't find any help online, hoping someone hear will be able to guide me in the right direction.

Mon 31 Jan 2022, 09:48 Trainer Jens said...

RE: SAP Connection to Power Query

Hi Lionel,

Thank you for the forum question and the nice feedback.

You will need to download and install the SAP HANA ODBC driver for the SAP HANA data connection to work properly.

Please follow the steps you can read in the Microsoft article (the link below)

https://docs.microsoft.com/en-us/power-query/connectors/sap-hana/overview

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Mon 7 Feb 2022: Automatically marked as resolved.

Excel tip:

Generating simple column charts

1.Select cell range containing data/figures
2. Press F11

View all Excel hints and tips

SAP Connection to Power Query

SAP Connection to Power Query

RE: SAP Connection to Power Query

Excel articles

Excel tip:

Generating simple column charts