Forum home » Delegate support and help forum » Microsoft Excel Training and help » SAP Connection to Power Query

SAP Connection to Power Query

ResolvedVersion 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:

Select only cell that contain text to lock format

For selecting cells that only contain Text in Excel

By selecting cells that only contain text, you can delete, fill or protect cells of this type.

Use short cut to Go to box (F5) or Edit, Go to
In the dialog box, click special button & select Constants and only check text or any other desired type.

Click OK.

And text cells will all be highlighted for you to apply format. Please note only works on one sheet at a time.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

SAP Connection to Power Query

SAP Connection to Power Query

RE: SAP Connection to Power Query

Excel articles

Excel tip:

Select only cell that contain text to lock format