Forum Discussion

JamesWo's avatar
JamesWo
New Member
4 years ago
Solved

Data connection to ADP

Has anyone ever connected Power BI to ADP (or any othe HR Information System) via the Web connection? I pulled information from here: https://developers.adp.com/articles/api/all and used the main URL...
General Comment
  • JamesWo's avatar
    JamesWo
    4 years ago

    The answer to my dilemma, is purchasing ADP's Data Cloud product. With that solution, ADP provides access to download the mez file for the connector. It’s not expensive but a little annoying. On the plus side, that also gives us access to all their benchmark data so that’s a huge win.

Razorbx13's avatar
Razorbx13
Post Patron
4 years ago

Benchmark data.............to you get access to the underlying tables as well?

JamesWol's avatar
JamesWol
New Member
4 years ago

Sorry for the late reply to everyone. I don't remember getting notifications that a reply was even posted. However, it's forcing me to log in to a federated account now and for some reason, it doesn't like my old user ID (hence the new handle).

 

All that to say, no. This turned out to be useless as all you get is the analyzed data, not the source data. That was quite disapointing. They do have a decent portal for viewing the metrics but if you have other non-HR KPIs in a dashboard, it would be nice to see everything together and also to minipulate the data for other KPIs that they aren't reporting on.

  • Sachintha's avatar
    Sachintha
    Helper III
    2 years ago

    JamesWol I know it has been some time since this post, but would you be able to explain how exactly you got this to work with the MEZ file? I'm in the same situation, but I do not know how to generate it as well as use it in PowerBI. Thanks!