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...
We have connected Data Factory to Paylocity and extracting data ok.
Did you connect through the API calls? If so, can you help explain how did you connect?
I was able to connect to paylocity using a web call in an ADF Azure pipeline that loads the data into a sql server db then I have power bi connected to sql server db. I used postman to test the authentication and api calls. I can post some steps later if anyone is interested.
I would be interested in this. I am trying to help a client with this
I'd be interested as well, woud love to incorproate ADF into our processes if it expedites connectivity with Paylocity for Power BI
- We have successfully connected Paylocity to SQL Server / Power BI / MS Azure Analysis Services. Please let me know if you are interested in having us provide this integration effort. It was not easy but is now given we have done the effort a number of times.
