power query

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

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

Power Query

resolvedResolved · Low Priority · Version 365

Puisum has attended:
Excel Advanced - Formulas & Functions course

Power Query

We are currently using Select HR but will more to WorkDay at the end of the year. Can Excel link to live data of these two HR systems?

RE: Power Query

Hi Pui-Sum,

Thank you for the forum question.

Unfortunately I have not been able to find an example of how to connect Power Query to Select HR but I would be very surprised if it is not possible based on my experience working with Power Query. All application developers always make sure the their applications can communicate with Microsoft's applications.

Below you will find a guide how to connect to WorkDay



https://www.cdata.com/kb/tech/workday-cloud-power-query.rst


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


 

Excel tip:

Create Charts with One keystroke

Create a graph with one click

1. Select your data.
2. Press F11.
3. You have a graph.

View all Excel hints and tips


Server loaded in 0.07 secs.