---
title: Statistics Reports - Connecting to Microsoft Power BI
description: Connect your Comtrac Statistics Reports to Power BI to build out report templates. Automatically refresh data to keep reports up to date.
---

[Skip to content](https://help.comtrac.com.au/statistics-reports-connecting-to-power-bi#main-content)

English

Show submenu for translations

[Contact us](https://help.comtrac.com.au/kb-tickets/new?hsLang=en) [Customer portal](https://help.comtrac.com.au/tickets-view?hsLang=en)

![comtrac-logo-2026-4](https://help.comtrac.com.au/hs-fs/hubfs/comtrac-logo-2026-4.png?width=300&height=80&name=comtrac-logo-2026-4.png)

- [Comtrac Help Centre](https://help.comtrac.com.au/)
- [Go to comtrac.com.au](https://comtrac.com.au/)
- [Contact Us](https://help.comtrac.com.au/kb-tickets/new)

Open main navigation

Close main navigation

- [Comtrac Help Centre](https://help.comtrac.com.au/)
- [Go to comtrac.com.au](https://comtrac.com.au/)
- [Contact Us](https://help.comtrac.com.au/kb-tickets/new)
- English
  
  Show submenu for translations
- [Contact us](https://help.comtrac.com.au/kb-tickets/new)
- [Customer portal](https://help.comtrac.com.au/tickets-view)
- Go to comtrac.com.au

 Go to comtrac.com.au

 Hello. How can we help you?

- There are no suggestions because the search field is empty.

1. [Comtrac Help Centre](https://help.comtrac.com.au/?hsLang=en)
2. [Reporting](https://help.comtrac.com.au/reporting?hsLang=en)
3. [Statistics Reports](https://help.comtrac.com.au/reporting?hsLang=en#statistics-reports)

# Statistics Reports - Connecting to Microsoft Power BI

## Connect your Comtrac Statistics Reports to Power BI to build out report templates. Automatically refresh data to keep reports up to date.

> Comtrac's Statistics Reports (see [Generate Statistics Reports](https://help.comtrac.com.au/statistics-reports-2024?hsLang=en)) are all API accessible, allowing users to import Comtrac data from them directly into Power BI (or similar applications) without the need to manually download spreadsheets. This data can also be set to refresh automatically to keep reports up to date.

#### Contents

- [Getting Started](https://help.comtrac.com.au/statistics-reports-connecting-to-power-bi#getting-started)
- [Step-by-Step](https://help.comtrac.com.au/statistics-reports-connecting-to-power-bi#step-by-step) 
    - [Building Comtrac Statistics Report API's](https://help.comtrac.com.au/statistics-reports-connecting-to-power-bi#building-report-apis)
    - [Connecting Comtrac Statistics Reports to Power BI](https://help.comtrac.com.au/statistics-reports-connecting-to-power-bi#connecting-comtrac-statistics-reports)
- [Next Steps](https://help.comtrac.com.au/statistics-reports-connecting-to-power-bi#next-steps) 
    - [Connecting Multiple Comtrac Statistics Reports to a Power BI Report](https://help.comtrac.com.au/statistics-reports-connecting-to-power-bi#connecting-multiple-reports)
    - [Automatically Refresh Power BI Report Data](https://help.comtrac.com.au/statistics-reports-connecting-to-power-bi#automatically-refresh-data)

#### ![PowerBI](https://help.comtrac.com.au/hs-fs/hubfs/PowerBI.png?width=369&height=149&name=PowerBI.png)

### GETTING STARTED

To get started you'll need:

1. The [**Power BI Desktop App**](https://www.microsoft.com/en-us/download/details.aspx?id=58494); and
2. A **Comtrac** Account.

### STEP-BY-STEP

#### Building Comtrac Statistics Report API's

Within Power BI reports you will need to add the [API endpoint](https://blog.hubspot.com/website/api-endpoint#:~:text=An%20API%20endpoint%20is%20a,a%20resource%20on%20the%20server.) (in the form of URL's) of each Comtrac Statistics Reports into them to import data. The URL's will look similar to the below example:

**EXAMPLE URL **

Report ID = 204 (Outcomes) | From Date = 11/22/2023 (MM/DD/YYYY Format)

```
https://test-cots.comtrac.com.au/bi/api/Report/statistics?FromDate=11%2F22%2F2023&ReportType=204&PageIndex=0&PageSize=500
```

**NOTE:** The API example above has only captured a "From Date" filter, which will return data from that date up until a current date. To add in a "To Date" filter range, see step [3.b.](https://help.comtrac.com.au/statistics-reports-connecting-to-power-bi#to-date)

 

**Steps to Build your Agency / Organisation Specific API URL:**

**NOTE:** The API URL sections that are in **bold**, are the sections that are being focused on for each step below. 

1. ```
   COMTRAC ENVIRONMENT DOMAIN: https://test-cots.comtrac.com.au/bi/api/Report/statistics?FromDate=11%2F22%2F2023&ReportType=204&PageIndex=0&PageSize=500
   ```
   
     1. Add in the domain of your organisation's Comtrac environment that you're importing data from in the same format as above (in this example, the environment we are using is Comtrac's internal test environment with the domain "test-cots.comtrac.com.au").
2. ```
   REPORT TYPE: https://test-cots.comtrac.com.au/bi/api/Report/statistics?FromDate=11%2F22%2F2023&ReportType=204&PageIndex=0&PageSize=500
   ```
   
     1. Leave this report type section as is.
3. ```
   FROM DATE: https://test-cots.comtrac.com.au/bi/api/Report/statistics?FromDate=11%2F22%2F2023&ReportType=204&PageIndex=0&PageSize=500
   ```
   
     1. Add in the "From Date" filter (MM/DD/YYYY) for your report in the same format as above (in this example we are looking to import data from the 11/22/2023 onwards).
        
            1. See [below](https://help.comtrac.com.au/statistics-reports-connecting-to-power-bi#date-filters) for the list of dates each report is filtering on.
            2. Date format is MM/DD/YYYY
     2. **"TO DATE" Filter Range (optional):** If required, add a "To Date" filter into the URL to specify a precise date range, which will look similar to the below (the "To Date" range below is 12/23/2024):
4. ```
   TO DATE: https://test-cots.comtrac.com.au/bi/api/Report/statistics?FromDate=11%2F22%2F2023&ToDate=12%2F23%2F2024&ReportType=204&PageIndex=0&PageSize=500
   ```
5. ```
   REPORT ID: https://test-cots.comtrac.com.au/bi/api/Report/statistics?FromDate=01%2F01%2F2023&ReportType=204&PageIndex=0&PageSize=500
   ```
   
     1. Add the relevant report ID (example above is 204 - Outcomes Report) from the list of [Statistics Reports](https://help.comtrac.com.au/statistics-reports-2024?hsLang=en) below in the same format as above. 
            1. Offences Report ID = **200**
            2. Entities Report ID = **201**
            3. Incidents Report ID = **202**
            4. Conclusions Report ID = **203**
            5. Outcomes Report ID = **204**
            6. Task Details Report ID = **205**
            7. Running Sheets Report ID =  **207**
            8. Property Report ID = **208**
            9. Triage Assessment Report ID = **209** 
6. ```
   PAGE INDEX: https://test-cots.comtrac.com.au/bi/api/Report/statistics?FromDate=11%2F22%2F2023&ReportType=204&PageIndex=0&PageSize=500
   ```
   
     1. Leave the page index set to 0 to return all relevant records starting from the first. To return all the records you need, you should only need to adjust the **Page Size** in step 6.
     2. **Incremental page indexes:** If needed you can apply incremental page indexes to return a specific number of results. For example, if the page index = 1 and the page size below = 10, the results returned will be results 11-20 (excluding the first 10). This is only ideal if you want to exclude some known results.
7. ```
   PAGE SIZE: https://test-cots.comtrac.com.au/bi/api/Report/statistics?FromDate=11%2F22%2F2023&ReportType=204&PageIndex=0&PageSize=500
   ```
   
     1. Add the number of records you want to return in your API URL. If you're unsure how many records you need to return, the recommended maximum page size is **500** records, with a theoretical maximum of **999999999 records**. 
            1. **NOTE:** If your report has **a large amount of records**, your query may timeout. If so, try limiting your records returned by reducing the page size and separating your queries by the page index, OR preferably, reducing your date range (See [Server Error / Timeouts](https://help.comtrac.com.au/statistics-reports-connecting-to-power-bi#server-error))
     2. **More than 999999999 records:** If you're unsure if the API URL has more than **999999999 **records associated, try adding PageIndex=1 into the URL and pasting it into your browser (e.g. https://test-cots.comtrac.com.au/bi/api/Report/statistics?FromDate=01%2F01%2F2023&ReportType=204&**PageIndex=1**&PageSize=999999999). If records are returned, you may also want to add this additional API URL into your Power BI reports to ensure data isn't excluded.

**SERVER ERROR / TIMEOUTS:** If your API query is timing out because there is a large amount of data being captured, try creating multiple queries of the same report ID with reduced date ranges instead to address this.

For example, if your date range is **01/22/2010 to current**, create two queries instead with the date range set to **01/22/2010 to 12/31/2017** and **01/01/2018 to current** respectively.

You can also try reducing your page size in a similar manner.

**Report Date Filters**

The From/To Date filter for each Report Type above relates to:

- **Offences (200):** Filters via the **Offence Date** (when the offence occurred).
- **Entities (201):** Filters via the Entity **Created Date.**
- **Incidents (202):** Filters via the Incident **Reported Date**.
- **Conclusions (203):** Filters via the Conclusion **Created Date.**
- **Outcomes (204):** Filters via the Outcome **Created Date of Outcome Results.**
- **Task Details (205):** Filters via the Task **Due Date.**
- **Running Sheets (207):** Filters via the **Running Sheet Date.**
- **Property (208):** Filters via the Property **Created Date.**
- **Triage Assessment (209):** Filters via the Assessment **Created Date.**

#### Connecting Comtrac Statistics Reports to Power BI

The below steps will walk through how to connect Comtrac Statistics Reports to a NEW Power BI Report:

1. Open the **Power BI Desktop** app and **Sign-In.**
2. Select **New** > **Report.[![image-png-Mar-23-2024-12-29-43-8266-AM](https://help.comtrac.com.au/hs-fs/hubfs/image-png-Mar-23-2024-12-29-43-8266-AM.png?width=655&height=287&name=image-png-Mar-23-2024-12-29-43-8266-AM.png)](https://help.comtrac.com.au/hubfs/image-png-Mar-23-2024-12-29-43-8266-AM.png?hsLang=en)**
3. From the new report, select **Get Data** > **Web.[![](https://help.comtrac.com.au/hs-fs/hubfs/image-png-Mar-23-2024-12-35-55-2989-AM.png?width=688&height=357&name=image-png-Mar-23-2024-12-35-55-2989-AM.png)](https://help.comtrac.com.au/hubfs/image-png-Mar-23-2024-12-35-55-2989-AM.png?hsLang=en)**
4. In the URL field, add in the Comtrac Statistics Report API URL created [above](https://help.comtrac.com.au/statistics-reports-connecting-to-power-bi#building-report-apis) and select **OK.** [![](https://help.comtrac.com.au/hs-fs/hubfs/image-png-Mar-23-2024-12-37-17-4004-AM.png?width=688&height=229&name=image-png-Mar-23-2024-12-37-17-4004-AM.png)](https://help.comtrac.com.au/hubfs/image-png-Mar-23-2024-12-37-17-4004-AM.png?hsLang=en)
5. From the **Access Web Content **pop-up that appears, navigate to **Basic **and enter in your Comtrac Username and Password. See the example user below:[![](https://help.comtrac.com.au/hs-fs/hubfs/image-png-Mar-23-2024-12-40-41-0963-AM.png?width=688&height=377&name=image-png-Mar-23-2024-12-40-41-0963-AM.png)](https://help.comtrac.com.au/hubfs/image-png-Mar-23-2024-12-40-41-0963-AM.png?hsLang=en) 
     1. **Forgot Comtrac Password: **If you have forgotten your Comtrac password or your agency / organisation uses Single-Sign On (SSO) and you've never had to enter a password, a user with **Comtrac Admin Access** will be able navigate into **Comtrac's User Management** page to update it for you.
     2. **Password Reset Caution (SSO Customers):** If your organisation or agency has set up SSO to access Comtrac and you reset your Comtrac password, you **WILL** need to **[clear all the cookies](https://support.google.com/accounts/answer/32050?hl=en&co=GENIE.Platform%3DDesktop) **on your browser before logging back into Comtrac to allow the system to "forget" your old password. You will also need to **close any existing windows** where Comtrac is open in your browser before opening a new window.
        
            1. If Comtrac is trying to remember your old password you will be taken to the below pop-up when attempting to access the system. **NEVER** enter your details in the below sign-in, you will be locked out in doing so. Follow the above steps instead.[![](https://help.comtrac.com.au/hs-fs/hubfs/image-png-Mar-23-2024-01-42-28-0391-AM.png?width=453&height=335&name=image-png-Mar-23-2024-01-42-28-0391-AM.png)](https://help.comtrac.com.au/hubfs/image-png-Mar-23-2024-01-42-28-0391-AM.png?hsLang=en)
6. Select **Connect **and wait for the **Power Query Editor **to open automatically with the Comtrac Statistics Report table now connected.[![](https://help.comtrac.com.au/hs-fs/hubfs/image-png-Mar-23-2024-12-44-37-6897-AM.png?width=688&height=397&name=image-png-Mar-23-2024-12-44-37-6897-AM.png)](https://help.comtrac.com.au/hubfs/image-png-Mar-23-2024-12-44-37-6897-AM.png?hsLang=en)
7. Select the expand (![](https://help.comtrac.com.au/hs-fs/hubfs/image-png-Mar-23-2024-12-46-12-9017-AM.png?width=20&height=19&name=image-png-Mar-23-2024-12-46-12-9017-AM.png)) icon in the **Data.Data **column heading of the imported table and then select **Expand to New Rows **to expand out the list of records in the table.[![](https://help.comtrac.com.au/hs-fs/hubfs/image-png-Mar-23-2024-12-48-48-3036-AM.png?width=289&height=131&name=image-png-Mar-23-2024-12-48-48-3036-AM.png)](https://help.comtrac.com.au/hubfs/image-png-Mar-23-2024-12-48-48-3036-AM.png?hsLang=en) 
     1. Your table should now look similar to the below:[![](https://help.comtrac.com.au/hs-fs/hubfs/image-png-Mar-23-2024-12-51-33-4966-AM.png?width=688&height=394&name=image-png-Mar-23-2024-12-51-33-4966-AM.png)](https://help.comtrac.com.au/hubfs/image-png-Mar-23-2024-12-51-33-4966-AM.png?hsLang=en)
8. Select the expand (![](https://help.comtrac.com.au/hs-fs/hubfs/image-png-Mar-23-2024-12-46-12-9017-AM.png?width=20&height=19&name=image-png-Mar-23-2024-12-46-12-9017-AM.png)) icon in the **Data.Data **column heading again which will now show a dropdown list of all record fields that can be displayed from the connected Comtrac Statistics Report.[![](https://help.comtrac.com.au/hs-fs/hubfs/image-png-Mar-23-2024-01-01-17-2419-AM.png?width=688&height=396&name=image-png-Mar-23-2024-01-01-17-2419-AM.png)](https://help.comtrac.com.au/hubfs/image-png-Mar-23-2024-01-01-17-2419-AM.png?hsLang=en) 
     1. **NOTE: **Uncheck 'Use original column name as prefix' if you don't want 'Data.Data' to appear before each column name, e.g. 'Data.Data.CaseId' becomes just 'CaseId'.
9. Choose the fields / columns you want to display and select **OK** to import all of the selected data.[![](https://help.comtrac.com.au/hs-fs/hubfs/image-png-Mar-23-2024-01-07-11-5448-AM.png?width=688&height=396&name=image-png-Mar-23-2024-01-07-11-5448-AM.png)](https://help.comtrac.com.au/hubfs/image-png-Mar-23-2024-01-07-11-5448-AM.png?hsLang=en)
10. Review and transform (edit headings, report name etc.) all of the imported records prior to saving this **Power Query** if required. 
      1. Check out [Microsoft's Guide](https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-query-overview) on transforming data in Power Query Editor for more details.
11. Once you're happy with the data, select **Close & Apply **to add the Comtrac Statistics Report to your Power BI report template.[![](https://help.comtrac.com.au/hs-fs/hubfs/image-png-Mar-23-2024-01-10-30-8413-AM.png?width=688&height=424&name=image-png-Mar-23-2024-01-10-30-8413-AM.png)](https://help.comtrac.com.au/hubfs/image-png-Mar-23-2024-01-10-30-8413-AM.png?hsLang=en)
12. From here you can start to build out and design your Power BI reports and templates using the connected Comtrac data. 
      1. To understand how to [connect multiple Comtrac Statistics Reports](https://help.comtrac.com.au/statistics-reports-connecting-to-power-bi#connecting-multiple-reports) and[automatically refresh report data](https://help.comtrac.com.au/statistics-reports-connecting-to-power-bi#automatically-refresh-data), refer to the [**NEXT STEPS**](https://help.comtrac.com.au/statistics-reports-connecting-to-power-bi#next-steps) section of this guide.

**Microsoft Learn:**

- [Get Started with Power BI Desktop](https://learn.microsoft.com/en-us/power-bi/fundamentals/desktop-getting-started)
- [Create and use Report Templates in Power BI Desktop](https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-templates)
- [Power Guery Web connector](https://learn.microsoft.com/en-us/power-query/connectors/web/web)

**Data Security: **Connected Comtrac Stastics Reports in Power BI will **ONLY** show data that you have access to in Comtrac itself.

### NEXT STEPS

#### **Connecting Multiple Comtrac Stastics Reports to a Power BI Report**

1. From an existing Power BI report select **Get Data > Web **and follow the [above steps](https://help.comtrac.com.au/statistics-reports-connecting-to-power-bi#connecting-comtrac-statistics-reports) to connect another Comtrac Statistics Report to it.
2. Once completed, select the **Data Model** icon (![](https://help.comtrac.com.au/hs-fs/hubfs/image-png-Mar-25-2024-12-13-15-0061-AM.png?width=24&height=24&name=image-png-Mar-25-2024-12-13-15-0061-AM.png)) to add a **relationship** between the two (or more) Comtrac Statistics Reports that have been connected.[![](https://help.comtrac.com.au/hs-fs/hubfs/image-png-Mar-25-2024-12-26-41-5006-AM.png?width=688&height=429&name=image-png-Mar-25-2024-12-26-41-5006-AM.png)](https://help.comtrac.com.au/hubfs/image-png-Mar-25-2024-12-26-41-5006-AM.png?hsLang=en) 
     1. **NOTE:** Adding a relationship allows meaningful insights to be drawn from across these multiple reports (in tables, graphs, charts and other visuals).
3. Select the ellipsis (![](https://help.comtrac.com.au/hs-fs/hubfs/image-png-Mar-25-2024-12-31-01-6559-AM.png?width=8&height=21&name=image-png-Mar-25-2024-12-31-01-6559-AM.png)) icon against the heading of one of the Comtrac Statistics Reports and navigate to **Manage Relationships.**[![](https://help.comtrac.com.au/hs-fs/hubfs/image-png-Mar-25-2024-12-34-34-4460-AM.png?width=688&height=427&name=image-png-Mar-25-2024-12-34-34-4460-AM.png)](https://help.comtrac.com.au/hubfs/image-png-Mar-25-2024-12-34-34-4460-AM.png?hsLang=en)
4. In the **Create Relationship **pop-up, select two Comtrac Statistics Reports (i.e. Conclusions and Outcomes) in the drop-down fields and highlight the **Caseid data column** in each report to add a relationship between them. A mandatory many-to-many relationship will be automatically set in the **cardinality **field. Ensure the cross filter direction is also set to **both**.[![](https://help.comtrac.com.au/hs-fs/hubfs/image-png-Mar-25-2024-01-09-40-6552-AM.png?width=688&height=691&name=image-png-Mar-25-2024-01-09-40-6552-AM.png)](https://help.comtrac.com.au/hubfs/image-png-Mar-25-2024-01-09-40-6552-AM.png?hsLang=en) 
     1. **NOTE:** Caseid is the recommend data column to add a relationship between as it is database generated, CAN'T be edited, and appears on EVERY Comtrac Statistics Report. 
5. Select **OK **to add the relationship to your Power BI report to beging building out visuals and templates. The relationship will appear similar to the below:[![](https://help.comtrac.com.au/hs-fs/hubfs/image-png-Mar-25-2024-12-56-58-0207-AM.png?width=688&height=326&name=image-png-Mar-25-2024-12-56-58-0207-AM.png)](https://help.comtrac.com.au/hubfs/image-png-Mar-25-2024-12-56-58-0207-AM.png?hsLang=en)

**Microsoft Learn:**

- [Work with Modelling view in Power BI Desktop](https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-modeling-view)

#### Automatically Refresh Power BI Report Data

With your Comtrac Statistics Report connected to Power BI, you can choose to automatically refresh the reports data on a daily or weekly basis to keep reports up to date. To do so:

1. **Publish** your Power BI report to a desired workspace (My workspace or Organizational).[![](https://help.comtrac.com.au/hs-fs/hubfs/image-png-Mar-24-2024-10-53-37-5368-PM.png?width=499&height=318&name=image-png-Mar-24-2024-10-53-37-5368-PM.png)](https://help.comtrac.com.au/hubfs/image-png-Mar-24-2024-10-53-37-5368-PM.png?hsLang=en)
2. Sign-in to the Power BI app (app.powerbi.com) on your browser to access your **workspaces**.
3. Select **Workspaces** and choose the workspace you published your report into.[![](https://help.comtrac.com.au/hs-fs/hubfs/image-png-Mar-25-2024-01-51-38-3314-AM.png?width=211&height=454&name=image-png-Mar-25-2024-01-51-38-3314-AM.png)](https://help.comtrac.com.au/hubfs/image-png-Mar-25-2024-01-51-38-3314-AM.png?hsLang=en)
4. Navigate to the relevant **Semantic Model** (Comtrac Statistics Report data)that is connected to your report and select the **Schedule Refresh **(![](https://help.comtrac.com.au/hs-fs/hubfs/image-png-Mar-24-2024-10-41-31-3642-PM.png?width=20&height=20&name=image-png-Mar-24-2024-10-41-31-3642-PM.png)) icon.[![](https://help.comtrac.com.au/hs-fs/hubfs/image-png-Mar-25-2024-01-50-16-6434-AM.png?width=688&height=386&name=image-png-Mar-25-2024-01-50-16-6434-AM.png)](https://help.comtrac.com.au/hubfs/image-png-Mar-25-2024-01-50-16-6434-AM.png?hsLang=en)
5. Select **Edit Credentials**in the Data source credentials failure warning that is diplayed.[![](https://help.comtrac.com.au/hs-fs/hubfs/image-png-Mar-25-2024-01-47-14-0495-AM.png?width=688&height=383&name=image-png-Mar-25-2024-01-47-14-0495-AM.png)](https://help.comtrac.com.au/hubfs/image-png-Mar-25-2024-01-47-14-0495-AM.png?hsLang=en)  
     1. **NOTE:** This warning displays before you enter in your Comtrac credentials for the first time in the Power BI App.
6. Select the **Basic **Authentication Method in the pop-up box that appears and enter in your Comtrac User name and Password, choose the desired privacy level setting for the data (Private or Organizational) and select **Sign-In**.**[![](https://help.comtrac.com.au/hs-fs/hubfs/image-png-Mar-24-2024-11-13-26-7481-PM.png?width=344&height=475&name=image-png-Mar-24-2024-11-13-26-7481-PM.png)](https://help.comtrac.com.au/hubfs/image-png-Mar-24-2024-11-13-26-7481-PM.png?hsLang=en)**
7. Navigate to the **Refresh **heading to set a **Refresh Schedule**.
8. Toggle the refresh scheduler **ON** and choose your refresh frequency (daily or weekly), time zone etc. and then **Apply** to set the schedule.**[![](https://help.comtrac.com.au/hs-fs/hubfs/image-png-Mar-24-2024-11-26-05-2280-PM.png?width=688&height=387&name=image-png-Mar-24-2024-11-26-05-2280-PM.png)](https://help.comtrac.com.au/hubfs/image-png-Mar-24-2024-11-26-05-2280-PM.png?hsLang=en)** 
     1. **NOTE: **You will also need to refresh your Power BI reports themselves to add the current data (from these Semantic Models) into your templates / visuals.
9. Repeat the process for any additional Semantic Models (Comtrac Statistics Reports) that have been connected into your Power BI reports.

**Microsoft Learn:**

- [Data refresh in Power BI](https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-data)
- [Automatic page refresh in Power BI Desktop](https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-automatic-page-refresh)

 

- [Quick Start Videos](https://help.comtrac.com.au/quick-start-videos?hsLang=en#main-content)
  
  
  
  
  
    - [Start Here](https://help.comtrac.com.au/quick-start-videos?hsLang=en#start-here)
    - [Create a Case](https://help.comtrac.com.au/quick-start-videos?hsLang=en#create-a-case)
    - [Record Investigative Activities](https://help.comtrac.com.au/quick-start-videos?hsLang=en#record-investigative-activities)
    - [Create & Export Investigation Report](https://help.comtrac.com.au/quick-start-videos?hsLang=en#create-export-investigation-report)
    - [A Couple of More Useful Quick Starts](https://help.comtrac.com.au/quick-start-videos?hsLang=en#a-couple-of-more-useful-quick-starts)
- [Comtrac Training](https://help.comtrac.com.au/comtrac-training?hsLang=en#main-content)
  
  
  
  
  
    - [Live training](https://help.comtrac.com.au/comtrac-training?hsLang=en#live-training)
    - [On-demand training](https://help.comtrac.com.au/comtrac-training?hsLang=en#on-demand-training)
- [Integrations & APIs](https://help.comtrac.com.au/integrations-apis?hsLang=en#main-content)
  
  
  
  
  
    - [Overview](https://help.comtrac.com.au/integrations-apis?hsLang=en#overview)
    - [SafetyCulture](https://help.comtrac.com.au/integrations-apis?hsLang=en#safetyculture)
    - [Open API Documentation Links](https://help.comtrac.com.au/integrations-apis?hsLang=en#open-api-documentation-links)
- [Online User Guides: Getting Access](https://help.comtrac.com.au/online-user-guides-getting-access?hsLang=en#main-content)
  
  
  
  
  
    - [How To Access Our Complete Library](https://help.comtrac.com.au/online-user-guides-getting-access?hsLang=en#how-to-access-our-complete-library)
- [Logging In / Changing Password](https://help.comtrac.com.au/logging-in-changing-password?hsLang=en#main-content)
  
  
  
  
  
    - [Logging In / Changing Password](https://help.comtrac.com.au/logging-in-changing-password?hsLang=en#logging-in-changing-password)
- [Homepage](https://help.comtrac.com.au/homepage?hsLang=en#main-content)
  
  
  
  
  
    - [Overview](https://help.comtrac.com.au/homepage?hsLang=en#overview)
- [Incident Search Table](https://help.comtrac.com.au/incident-search-table?hsLang=en#main-content)
  
  
  
  
  
    - [Overview](https://help.comtrac.com.au/incident-search-table?hsLang=en#overview)
- [Incident / Case Administration](https://help.comtrac.com.au/incident-case-administration?hsLang=en#main-content)
  
  
  
  
  
    - [Overview](https://help.comtrac.com.au/incident-case-administration?hsLang=en#overview)
- [Investigation Management](https://help.comtrac.com.au/investigation-management?hsLang=en#main-content)
  
  
  
  
  
    - [Overview](https://help.comtrac.com.au/investigation-management?hsLang=en#overview)
- [Case Reports](https://help.comtrac.com.au/case-reports?hsLang=en#main-content)
  
  
  
  
  
    - [Overview](https://help.comtrac.com.au/case-reports?hsLang=en#overview)
- [Field Notes](https://help.comtrac.com.au/field-notes?hsLang=en#main-content)
  
  
  
  
  
    - [Overview](https://help.comtrac.com.au/field-notes?hsLang=en#overview)
- [Intelligence Reports](https://help.comtrac.com.au/intelligence-reports?hsLang=en#main-content)
  
  
  
  
  
    - [Overview](https://help.comtrac.com.au/intelligence-reports?hsLang=en#overview)
- [AI Features](https://help.comtrac.com.au/ai-features?hsLang=en)
- [Search](https://help.comtrac.com.au/search?hsLang=en#main-content)
  
  
  
  
  
    - [Overview](https://help.comtrac.com.au/search?hsLang=en#overview)
- [System Administration](https://help.comtrac.com.au/system-administration?hsLang=en#main-content)
  
  
  
  
  
    - [Overview](https://help.comtrac.com.au/system-administration?hsLang=en#overview)
- [Resources](https://help.comtrac.com.au/resources?hsLang=en#main-content)
  
  
  
  
  
    - [Overview](https://help.comtrac.com.au/resources?hsLang=en#overview)
- [Reporting](https://help.comtrac.com.au/reporting?hsLang=en#main-content)
  
  
  
  
  
    - [Overview](https://help.comtrac.com.au/reporting?hsLang=en#overview)
    - [Statistics Reports](https://help.comtrac.com.au/reporting?hsLang=en#statistics-reports)
- [Public Portal](https://help.comtrac.com.au/public-portal?hsLang=en#main-content)
  
  
  
  
  
    - [Overview](https://help.comtrac.com.au/public-portal?hsLang=en#overview)
- [Mobile Field Application - 'Comtrac Frontline'](https://help.comtrac.com.au/mobile-field-application-comtrac-frontline?hsLang=en)
- [BAU Release Schedule](https://help.comtrac.com.au/bau-release-schedule?hsLang=en#main-content)
  
  
  
  
  
    - [BAU Release Schedule](https://help.comtrac.com.au/bau-release-schedule?hsLang=en#bau-release-schedule)
- [Release Notes](https://help.comtrac.com.au/release-notes?hsLang=en#main-content)
  
  
  
  
  
    - [Change Log](https://help.comtrac.com.au/release-notes?hsLang=en#change-log)
- [ICETS](https://help.comtrac.com.au/icets?hsLang=en)
- [Archived User Guides](https://help.comtrac.com.au/archived-user-guides?hsLang=en#main-content)
  
  
  
  
  
    - [Divisions Release Notes](https://help.comtrac.com.au/archived-user-guides?hsLang=en#divisions-release-notes)
- [Product Webinar Recordings](https://help.comtrac.com.au/product-webinar-recordings?hsLang=en)

- [About Us](https://www.comtrac.com.au/about-us/)
- [Book a demo](https://www.comtrac.com.au/book-a-demo/)
- [Privacy Policy](https://www.comtrac.com.au/privacy-policy/)
- [Terms of Use](https://www.comtrac.com.au/terms-of-use/)

[![Comtrac](https://help.comtrac.com.au/hs-fs/hubfs/CMT_Logo_Master_CMT_Main_Horizontal-1.png?width=102&height=24&name=CMT_Logo_Master_CMT_Main_Horizontal-1.png "Comtrac")](http://comtrac.com.au)

comtrac.com.au Help Center

Copyright © 2026, Comtrac