Articles on: Billing & Analytics

Advanced Reporting FAQ

What is Advanced Reporting?

Advanced Reporting gives you direct access to your travel data from C Teleport.

Get secure access to your company’s booking and invoice data so you can build your own internal reports and dashboards in tools like Power BI or Excel.

You decide how the data is structured, analysed, and presented.


What kind of data can I access?

You can access detailed data from your:

  • Flight and hotel bookings
  • Invoices
  • Extra services
  • Traveller and user records

The dataset includes more fields than what you see in the standard interface.

We continuously expand the available data in response to customer requests.


How can I work with reporting data?

1. Power BI Template

You can use our optional Power BI template as a starting point. It contains pre-built visualisations based on a subset of available data.

You can customise it further to match your internal reporting needs.

2. Excel Access

You can connect Excel directly to the data source and download raw tables. This allows you to create your own pivot tables, financial reviews, or internal reports.

3. Direct API (OData) Connection

You can connect your BI tool or internal system directly via OData and build fully customised dashboards. All three methods use the same data source and can be combined.


Is there a ready-made dashboard included?

No — Advanced Reporting gives you data access, not a fully managed dashboard service.


How does the data connection work?

Your data is stored in a secure reporting environment. You receive access credentials from your Customer Success Manager (teamcs@teleport.com).

Using these credentials, you connect your reporting tool (Power BI, Excel, or another BI system) to: https://reporting.cteleport.com/v2/odata

Once connected, your reports pull live data directly from C Teleport.


How often is the data updated?

Your reporting data is updated daily at 15:00 CET.


How do I get access?

  1. Contact your Customer Success Manager.
  2. We generate a unique Reporting Access Key for you.
  3. You receive: name (username) and password

For security reasons, the password is not stored after creation. Please store it securely.


How can I access my Excel tables?

Recording is coming.

You can connect Excel directly to your data source using OData. This allows you to create your own reports, pivot tables, and analyses using live data from our system.


Step-by-Step Connection Process
  1. Open Excel: Launch Microsoft Excel on your computer
  2. Access Data tab: Go to the "Data" tab in the Excel ribbon
  3. Get Data: Click "Get Data" > "From Other Sources" > "From OData Feed"
  4. Enter OData URL: Paste the following URL into the URL field: https://reporting.cteleport.com/v2/odata
  5. Choose authentication type: Select "Basic" authorization
  6. Select your table: Choose the desired table from the available options (e.g., "Users")
  7. Enter credentials:
    • Name: [your access name, which you received from our Customer Success Manager]
    • Password: [your password, which you received from our Customer Success Manager]
  1. Connect: Click the "Connect" button
  2. Data loading: The data will now be loaded and presented in Excel
  3. Load or Transform: Either load the data directly into Excel or use "Transform Data" to modify it first in Power Query Editor
  4. Refresh settings: Configure automatic refresh settings if you want the data to update periodically


How can I access my Power BI template?



You can download the Power BI template here.

When you first open the .pbit template file, in Power BI desktop app, you won't see any data displayed. This is expected behavior - the template contains the dashboard structure and visualizations, but requires your unique access keys to connect to the data source.


Step-by-Step Setup Process
  1. Open the template: Load the .pbix file in Power BI Desktop or upload it to Power BI Service
  2. Connection prompt: Power BI will detect the OData connection, but won't be able to authenticate automatically
  3. Configure credentials: You'll be prompted to "Enter credentials" or you can manually go to "Data source settings"
  4. Enter your API keys: Input the specific credential keys that we've provided to you for accessing the data.
    1. Enter OData URL: Paste the following URL into the URL field: https://reporting.cteleport.com/v2/odata
    2. Name: [your access name, which you received from our Customer Success Manager]
    3. Password: [your password, which you received from our Customer Success Manager]
  6. Data connection: Power BI will establish a connection to our data source through the OData endpoint
  7. Dashboard population: The data will refresh and populate all charts, tables, and visualizations in your dashboard


What are Reporting Access Keys?

Your access consists of:

  • Name
  • Password

These credentials allow your BI or reporting tool to securely connect to your company’s data.

You are responsible for keeping them secure and sharing them only internally with authorised colleagues.


What if I lose my credentials?

Contact your Customer Success Manager.

We will deactivate the old key and generate a new one.


What if the credentials are compromised?

If you suspect unauthorised access, contact us immediately.

We will deactivate the key to prevent misuse and issue a new one.


Updated on: 05/03/2026

Was this article helpful?

Share your feedback

Cancel

Thank you!