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...
@darrenfishell We're doing a GET request only integration. It's possible using the Web Contents connector. You need to iterate through the pages until you receive an empty result, and then use a list combine to append them together. Use independent functions in PowerQuery editor. The issue we're running into now is that Paylocity requires {employeeID} in the URL to reach the other endpoints for a GET request. Using a Relative Path to jump a step and iterate across employee ID with a merge is problematic because it would exponentially increase the API calls and get limited by Paylocity.