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.

     

AjiteshChurewal's avatar
AjiteshChurewal
Frequent Visitor
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.