Onfleet to Power BI

This page provides you with instructions on how to extract data from Onfleet and analyze it in Power BI. (If the mechanics of extracting data from Onfleet seem too complex or difficult to maintain, check out Stitch, which can do all the heavy lifting for you in just a few clicks.)

What is Onfleet?

Onfleet is logistics management software and route optimization for businesses offering last-mile delivery. Onfleet helps businesses assign and track local deliveries and communicate with drivers and customers. It includes smartphone apps for drivers to receive tasks, a web dashboard for dispatchers to manage and analyze operations, and automatic notifications and tracking for recipients.

What is Power BI?



Getting data out of Onfleet

Onfleet provides a RESTful API that lets developers retrieve data stored in the platform about workers, destinations, recipients, and more. For example, to get information a list of all teams, you would call GET https://onfleet.com/api/v2/teams.

Sample Onfleet data


    "id": "yKpCnWprM1Rvp3NGGlVa5TMa",
    "timeCreated": 1455048584000,
    "timeLastModified": 1455049756016,
    "name": "FiDi",
    "workers": [
    "managers": [
    "hub": null,
    "tasks": [
  // ...
    "id": "R4P7jhuzaIZ4cHHZE1ghmTtB",
    "timeCreated": 1455048567000,
    "timeLastModified": 1455073711646,
    "name": "Tenderloin",
    "workers": [
    "managers": [
    "hub": "E4s6bwGpOZp6pSU3Hz*2ngFA",
    "tasks": [

Preparing Onfleet data



Loading data into Power BI



Analyzing data in Power BI




Keeping Onfleet data up to date


The key is to build your script in such a way that it can identify incremental updates to your data. Thankfully, Onfleet's API results include fields like timeCreated and timeLastModified that allow you to identify records that are new since your last update (or since the newest record you've copied). Once you've take new data into account, you can set your script up as a cron job or continuous loop to keep pulling down new data as it appears.

From Onfleet to your data warehouse: An easier solution

As mentioned earlier, the best practice for analyzing Onfleet data in Power BI is to store that data inside a data warehousing platform alongside data from your other databases and third-party sources. You can find instructions for doing these extractions for leading warehouses on our sister sites Onfleet to Redshift, Onfleet to BigQuery, Onfleet to Azure SQL Data Warehouse, Onfleet to PostgreSQL, Onfleet to Panoply, and Onfleet to Snowflake.

Easier yet, however, is using a solution that does all that work for you. Products like Stitch were built to move data from Onfleet to Power BI automatically. With just a few clicks, Stitch starts extracting your Onfleet data via the API, structuring it in a way that's optimized for analysis, and inserting that data into a data warehouse that can be easily accessed and analyzed by Power BI.