Power BI Integrations

Trax Power BI integrations enable you to build custom dashboards and reporting around your Trax data, updating realtime from a single source of truth.

General

To setup Power BI integrations, you will need to:

  1. Create a new dataset in a Power BI workspace. workspace

  2. Choose the API option. dataset

  3. Set up the fields as described in the below sections. Currently supported data is work instructions, issues and assets.

asset_schema

Data Format

Set up the streaming dataset fields to match the below format.

Work Instructions 

[
    {
    "title" :"AAAAA555555",
    "description" :"AAAAA555555",
    "id" :"AAAAA555555",
    "total" :98.6
    "complete" :98.6
    "cancelled" :"AAAAA555555",
    "locked" :"AAAAA555555",
    }
]

Assets 

[
    {
    "title" :"AAAAA555555", 
    "type": :"AAAAA555555", 
    "chainage" :98.6,
    "total" :98.6,
    "complete" :98.6,
    "deleted" :"AAAAA555555", 
    }
]

Issues 

[
    {
    "issueId" :"AAAAA555555",
    "title" :"AAAAA555555",
    "type" :"AAAAA555555",
    "status" :"AAAAA555555",
    "description" :"AAAAA555555",
    }
]