Power BI

Needs Votes

Workday HR

Vote (598)

Lance Austin on 05 Dec 2014 22:00:13

I would love to have the ability to do reporting against Workday. We leverage it as our global HR platform. It has some really good reporting but it would be nice to have the ability but it would be great to be able to share reporting with SharePoint and Power BI so that we can surface non sensitive data up in dashboards.

Comments (67)

Greg on 05 Jul 2020 23:45:09

RE: Workday HR

Any update on this? We need Microsoft to listen to their customers and build a Workday HR connector!

Nayan Patel on 05 Jul 2020 23:33:21

RE: Workday HR

ZappySys has announced Generic SOAP / REST API connector which you can use to pull data from WorkDay SOAP Web Service in Power BI or other ODBC tools. Check below link https://zappysys.com/blog/connect-workday-power-bi-import-soap-data/

Here is sample SQL query

SELECT * FROM $
/*Below WITH clause is optional, uncomment parameter(s) values you like to set
which are different than DSN properties.
*/
WITH(
Src='https://xxxxxxxxxx.workday.com/ccx/service/yyyyyyyyy/Human_Resources'
--,ElementsToTreatAsArray='wd:Worker'
--,DataConnectionType='HTTP'
--,SoapWssPasswordType='PasswordDigest'
--,UserName='testuser001'
--,CredentialType='SoapWss'
--,Filter='$.env:Envelope.env:Body.wd:Get_Workers_Response.wd:Response_Data.wd:Worker[*]'
--,RequestContentTypeCode='TextXmlUtf8'
--,RequestMethod='POST'
--,Header='SOAPAction: ""'
,RequestData='

.......... .......... ..........
.......... FROM SOAPUI .........
.......... .......... ..........

'
)

Luke Manterfield on 05 Jul 2020 23:32:25

RE: Workday HR

This would be invaluable to us as we implement Workday. Otherwise we'll need to use SOAP and call Workday's API, import to SQL then use SQL as the data source. This is not really the most efficient way of doing this - a connector would be far better!

CCE on 05 Jul 2020 23:27:46

RE: Workday HR

Would be awesome!

Iman Eftekhari on 05 Jul 2020 23:24:30

RE: Workday HR

Any update on this? Workday is a popular HR system and this would be a great feature to have.
We have created our HR packaged solution based on that but not using a direct connector.
See here a demo version of that: https://powerbi.microsoft.com/en-us/partner-showcase/agile-analytics-hr-analytics/

Asad on 05 Jul 2020 23:22:24

RE: Workday HR

Did this ever got completed. I am searching for PowerBI - Workday connector... Found this post on top but its from 2014

Nayan Patel on 05 Jul 2020 23:22:24

RE: Workday HR

Workday API is XML SOAP Service. ZappySys has created an easy to use ODBC drivers for REST / SOAP API access so you just write SQL queries to access data in any ODBC compliant apps (e.g. Power BI, Tableau, Qlik, SSRS).

Please refer this article to learn how to call SOAP API (e.g. Workday API) in Power BI
https://zappysys.com/blog/call-soap-api-power-bi-read-xml-web-service-data/

Hope this helps!