Forum Discussion

jl20's avatar
jl20
Icon for Helper IV rankHelper IV
7 years ago

Workday ERP connector

Hi all,   I was wondering if anyone has insight into reporting out of Workday on Power BI. It doesn't look like a native connector exists, so is the best workaround to schedule Workday reports to C...
Need Help
jl20's avatar
jl20
Icon for Helper IV rankHelper IV
7 years ago

It's a SOAP API. The database is object-oriented, so it's unclear how I'd create the data model within PBI even if I was able to connect. Seems like I'd need to report out of Workday into a flat file and then load that into PBI. What do you think?

Chihiro's avatar
Chihiro
Icon for Solution Sage rankSolution Sage
7 years ago

What I'd do is following.

 

Have some script/code that runs on schedule to grab data from SOAP API. Have db with stored proc or have some process push data to db. This ensures you store it in the format that's easy to handle with PowerBI.

 

Added benefit is that you can create Views and such for quick consumption by PowerBI.

 

Do note that you'll need gateway server set up for this.