Forum Discussion
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 address of https://api.adp.com. However, when our HR staff types in their credentials, they get a "couldn't authenticate" error message. I have a call scheduled with ADP tomorrow where I think they are going to try and sell us something but I am curious to know if anyone else has done this successfully.
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.
14 Replies
Hi JamesWo ,
Try to make a requisition of authentication.Each API is different from each other, therefore you need to read the API specification before using it.Pleae Try send the Token address, Username, and Password in power query.
You can refer to these blogs:
https://www.linkedin.com/pulse/accessing-api-oauth2-using-m-language-power-bi-diogenes-santos
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.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.
correct
Benchmark data.............to you get access to the underlying tables as well?
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.
James,
My mez file connector is limiting the import to 50 rows. Have you found a workaround for this?
No, as I kind of gave up on pulling this in to PBI after I realized I wasn't getting the source data. However, they recently updated their mez file so I haven't see what the changes are.
Is it possible to do scheduled refreshes with ADP Cloud Connector? I am having the same problem.
