topic Re: Data connection to ADP in Developer

Data connection to ADP

JamesWo — Thu, 03 Feb 2022 16:39:43 GMT

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.

Re: Data connection to ADP

V-lianl-msft — Mon, 07 Feb 2022 02:25:05 GMT

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.kasperonbi.com/getting-data-into-power-query-with-the-twitter-search-api-how-to-hack-pq-to-use-oauth/

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.

Re: Data connection to ADP

JamesWo — Tue, 08 Feb 2022 00:06:15 GMT

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.

Re: Data connection to ADP

Anonymous — Thu, 10 Mar 2022 22:32:19 GMT

Is the mez connector for Power BI (custom connector)?

Re: Data connection to ADP

Razorbx13 — Wed, 16 Mar 2022 16:22:55 GMT

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

Re: Data connection to ADP

badkins2 — Mon, 04 Apr 2022 17:28:54 GMT

James,

My mez file connector is limiting the import to 50 rows. Have you found a workaround for this?

Re: Data connection to ADP

joless — Wed, 08 Jun 2022 21:30:02 GMT

Hi Bud. Do you know if the ADP Data Cloud product, specifically the Mez file, will allow the report to be published and use a Data Refersh schedule?

Re: Data connection to ADP

JamesWol — Mon, 13 Jun 2022 21:03:28 GMT

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.

Re: Data connection to ADP

JamesWol — Mon, 13 Jun 2022 21:03:48 GMT

correct

Re: Data connection to ADP

JamesWol — Mon, 13 Jun 2022 21:04:32 GMT

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.

Re: Data connection to ADP

JamesWol — Mon, 13 Jun 2022 21:05:25 GMT

I don't see any reason why it wouldn't but I haven't personally tested it and have given up on the connection for the moment since I don't get the source data.

Re: Data connection to ADP

badkins2 — Mon, 13 Jun 2022 21:08:37 GMT

They fixed the 50 row import problem, but I have also given up, as I am getting errors and incomplete datasets on import.

Re: Data connection to ADP

joless — Mon, 13 Jun 2022 21:17:38 GMT

Have you tried publishing the report and scheduling a data refresh? When I tried with a Mez file that was created last week, scheduling a data refresh was not an option and it displayed a message of "You can't schedule refresh for this dataset because the following data sources currently don't support refresh: Data source for Query1".

Re: Data connection to ADP

Sachintha — Wed, 29 May 2024 20:49:55 GMT

@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!

Re: Data connection to ADP

Shaunting — Thu, 15 Aug 2024 21:07:49 GMT

Is it possible to do scheduled refreshes with ADP Cloud Connector? I am having the same problem.