How to integrate Paylocity and Ceipal data

[tejaswib]

How to integrate Paylocity and Ceipal data with Power BI Desktop?
What is the best approach to get the data with both the systems?

Can anyone please help me with the solution.

Thank You

Tejaswi

[christinepayton · Accepted solution]

There's not a connector for those, so you would need a data integrations person to set up ETL to copy the data into a supported source (like SQL). There's a slew of tools to do this; some have connectors built in for specific sources to make it easier for you. You can connect directly to APIs in PBI, but it is better to store the data in a database. 

[christinepayton · Accepted solution]

There's not a connector for those, so you would need a data integrations person to set up ETL to copy the data into a supported source (like SQL). There's a slew of tools to do this; some have connectors built in for specific sources to make it easier for you. You can connect directly to APIs in PBI, but it is better to store the data in a database. 

[tejaswib · Accepted solution]

Thanks for your reply.