Power BI Connector for TSheets

Build 20.0.7654


Retrieves a list of all geofence configs.

Table Specific Information


Query the GeoLocations table. 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.

  • Id, UserId and GroupId fields support the '=' and IN operators.
  • LastModified field supports the <=,<,>=,>,= operators.

For example, the following query is processed server side:

SELECT * FROM GeoLocations WHERE GroupId IN ('29474', '29474') AND LastModified <= '2020-01-01 00:00'


Name Type Description
Id [KEY] Int Id of geolocation.
UserId Int User id for the user that this geolocation belongs to.
Accuracy Double Indicates the radius of accuracy around the geolocation in meters.
Altitude Double Indicates the altitude of the geolocation in meters.
Latitude Double Indicates the latitude of the geolocation in degrees.
Longitude Double Indicates the longitude of the geolocation in degrees.
Speed Double Indicates the speed of travel (meters per second) when the geolocation was recorded.
Source String Indicates how the GPS point was obtained. One of 'gps', 'wifi', or 'cell'.
DeviceIdentifier String Unique identifier (for the given client) for the device associated with this geolocation.
Created Datetime Date/time when this geolocation was created


Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
LastModified Datetime Date/time when this geofence config was last modified.
GroupId String A comma-separated list of group ids. Only geolocations linked to users from these groups will be returned.

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