Power BI Connector for TSheets

Build 20.0.7654

ProjectReport

Retrieves a project report.

Table Specific Information

Select

Query the ProjectReport table to retrieve a project report, broken down by user, group or jobcode. The connector will use the TSheets API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the connector. By default the report will include results for a time range within the last 30 days. You can filter by StartDate and EndDate filters to get a payroll report over a different time range.

  • UserId, JobcodeId and GroupId fields support the '=' and IN operators.
  • StartDate and EndDate fields support the '=' operator.

For example, the following queries are processed server side:

SELECT * FROM ProjectReport WHERE GroupId IN (29474, 29474)
SELECT * FROM ProjectReport WHERE StartDate = '2019-11-01' AND EndDate = '2019-12-31'

Based on the columns selected in projection explicitly, the aggregated data displayed may change. Aggregate projects metrics broken down by user id:

SELECT * FROM ProjectReport WHERE StartDate = '2019-11-01' AND EndDate = '2019-12-31'
SELECT UserId, TotalHours FROM ProjectReport WHERE StartDate = '2019-11-01' AND EndDate = '2019-12-31'

Aggregate project metrics broken down by jobcode id:

SELECT JobCodeId, TotalHours FROM ProjectReport

Aggregate payroll metrics broken down by group id:

SELECT GroupId, TotalHours FROM ProjectReport

Columns

Name Type Description
UserId Int Id of the users these totals are calculated for.
JobcodeId Int Id of the jobcode the metrics apply to.
GroupId Int Id of the group the metrics apply to.
StartDate Date Start of reporting timeframe.
EndDate Date End of the payroll reporting timeframe.
TotalHours Double Total number of hours per each user, group or jobcode.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654