Power BI

Needs Votes

Workday HR

Vote (418)

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 (59)

Comments (59)

2a090d9b a757-4a5c-b1f8-73b78bac7ddb on 10 Jul 2020 17:22:29

RE: Workday HR

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 Power BI so that we can surface non sensitive data up in dashboards.

fd4a0771 85f8-4111-91a9-b57f1f6f2932 on 10 Jul 2020 17:22:02

RE: Workday HR

Hi!

With more companies going with Workday for their HCM and Financials, it will be a great value add to seamlessly connect to Workday datasource. This will be a value add for us!

Thanks

fbf78a8e 2aa7-4c92-b5f8-a5bf0df9ea66 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!

879170cf 37b0-4ed5-8d61-1f127f0fe7b2 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 .........
.......... .......... ..........

'
)

732c1e35 e2e5-4db4-b974-b6435fa9421d 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!

344ba9a4 1d67-452c-8e36-3d4f05e5a25e on 05 Jul 2020 23:27:46

RE: Workday HR

Would be awesome!

fd3109dc 8675-41cf-a32a-6897b4d711cc 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/

252cc132 6f9c-4100-bf90-7cbb746c8bd2 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

879170cf 37b0-4ed5-8d61-1f127f0fe7b2 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!

328198f9 4812-4986-b281-06bc80a1b988 on 05 Jul 2020 23:20:46

RE: Workday HR

is this going to happen?????