Data Connector: Fleet Data in Power BI, Excel and Tableau Without the API

Data Connector is a no-code connector that puts the platform's aggregated fleet data into Power BI, Excel and Tableau as tables, refreshed daily. Finance gets cost per kilometre next to revenue, and operations gets utilization next to the work-order backlog. The High Point GPS platform already has every report a fleet manager needs. The rest of the company works in Power BI, Excel or Tableau, and getting fleet data there has meant exporting reports by hand or asking a developer to write against the API. Data Connector replaces the manual export.

You get pre-built, aggregated datasets instead of raw telemetry: vehicle and driver summaries by day, trips and distance, fuel and idle, safety events and scores, utilization, maintenance and fault codes, EV charging and battery data, plus the fleet's groups so the numbers slice the way your organization does. The platform does the aggregation, so the BI tool receives clean tables sized for a dashboard, not millions of GPS points. Power BI, Excel and Tableau all connect to it as an OData feed.

Cost-per-kilometre dashboards that set fuel, maintenance and telematics data beside finance's own figures. Utilization reports that justify or cancel the next vehicle purchase. Safety scorecards merged with HR records to run a bonus program. Sustainability reports on fuel, idle and EV charging for a customer's or a board's ESG requirements. And for municipalities, dashboards that put fleet data in the same tool as the rest of the city's operating reports.

Data Connector handles reporting on aggregated data. Real-time integration, such as a dispatch system that needs positions now or a work-order system that needs a fault code the moment it fires, still runs through the High Point GPS API, and that is where High Point GPS builds custom integrations. Many fleets run both: the connector for dashboards and the API for operational systems.

A first dashboard takes an afternoon. Open Power BI Desktop, choose Get Data, select OData Feed and paste the access URL that High Point GPS gives you during setup. Sign in with your platform database name and user name, then your password. Pick the tables you need (usually the daily vehicle and driver summaries, the daily safety tables and the device groups) and load them. Build a date table, relate the summaries to it, then add the device groups table so you can slice every visual by depot or division. Start with three visuals: distance and fuel per vehicle per month, idle percentage by group, and safety events per 100 km by driver. Publish to the Power BI service and schedule a daily refresh, since the connector's data updates once a day. Excel loads the same tables through Get Data and OData Feed, and Tableau through its OData connector, so the same tables serve all three tools.