Forum Discussion

AliPoa's avatar
AliPoa
Frequent Visitor
6 months ago
Solved

Unable to refresh PeopleHR API connection in PB Service when combining tables

Hello, Please can anyone offer advice on the following?   I have used Power Query in a PBI report to access the PeopleHR API. I am drawing down both the Employee Table and Timesheets table, merging...
Need Help
  • AjiteshChurewal's avatar
    AjiteshChurewal
    6 months ago

    Hi,

    Since the Employee API runs successfully on its own, the issue appears to be related to the Timesheet API, which is currently being executed separately for each Employee ID.

    I would recommend retrieving the timesheet data in bulk instead of making individual API calls per employee. Fetching the data in a single request should help avoid refresh issues and improve overall performance and reliability.

     

v-hjannapu's avatar
v-hjannapu
Community Support
5 months ago

Hi AliPoa,

I would also take a moment to thank AjiteshChurewal  , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Regards,
Community Support Team.