Forum Discussion
Connecting to Paylocity
Hi, I am curious if anyone has connected PowerBI to Paylocity. I have been using PowerBI by connecting it to our erp system (using an ODBC) but have been struggling to find a way to connect Paylo...
I am working through this now. My research has indicated that a custom connector is needed to retrieve any Paylocity data because the API handles pagination via the response header, which is not visible in PowerQuery in PowerBI Desktop or in Dataflows.
The other option is a separate ETL process, in Python or something else that is a little more straightforward for handling HTTP requests.