Forum Discussion
Connecting to Paylocity
Anonymous,
You can review this blog about how to use Paylocity API to get data. To connect to the api in Power BI Desktop, you can use web connector or directly add Power Query code in Advanced Editor of a blank query, for more details, please review the following blog:
https://chris.koester.io/index.php/2015/07/16/get-data-from-twitter-api-with-power-query/
Regards,
Lydia
Had anyone able to connect to paylocity
- KF13 years agoNew Member
We have connected Data Factory to Paylocity and extracting data ok.
- BA-Bandit3 years agoRegular Visitor
Did you connect through the API calls? If so, can you help explain how did you connect?
- BA-Bandit2 years agoRegular Visitor
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.