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.

JamesWo's avatar
JamesWo
New Member
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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

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

    • JamesWol's avatar
      JamesWol
      New Member
      4 years ago

      correct

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

  • badkins2's avatar
    badkins2
    Frequent Visitor
    4 years ago

    James,

     

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

    • JamesWol's avatar
      JamesWol
      New Member
      4 years ago

      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.

      • badkins2's avatar
        badkins2
        Frequent Visitor
        4 years ago

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

  • joless's avatar
    joless
    New Member
    4 years ago

    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?

    • JamesWol's avatar
      JamesWol
      New Member
      4 years ago

      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.