LogoTime Impact AISaaS Licensing Portal

Help

Contact Support

Alternative: email us at contact@timeimpactai.com
Tip: include the exact error message + your app version to speed up support.

How to use TimeImpactAI (EXE)

1) Install and Run

  1. Download the latest TimeImpactAI EXE.
  2. Double-click the EXE to run.
  3. If Windows SmartScreen shows a warning: click More info → Run anyway.

2) Sign in and Verify License

  1. Open the app and go to the Subscription / Sign-in section.
  2. Enter your portal email + password.
  3. Click Verify.
✅ If your subscription/trial is active you will see Verified. The app needs internet to verify.

3) Run ETL (Primavera P6 XER files → Power BI-ready data)

TimeImpactAI performs ETL to create a direct analytics connection between Primavera P6 XER files and Microsoft Power BI. It parses XER files, normalizes the data into structured tables, and prepares datasets ready for reporting and dashboards.
The ETL considers key schedule and reporting elements, including:
  • Drawings / WBS mapping (if provided in your setup)
  • S-Curves and progress curves
  • Calendars, non-working days, and calendar exceptions
  • Resource curves, resource loading, and assignments
  • Historical update XERs to extract periodic actuals and progress trends
  1. Click Run ETL.
  2. Select your Baseline folder (contains baseline XER file(s)).
  3. Select your Update folder (contains periodic / updated XER file(s)).
  4. Choose output mode:
    • SQLite: choose an output folder and the app will generate a local SQLite database file.
    • SQL Server (recommended for enterprise): the app will detect your SQL Server instance and you will provide a database name to create.
  5. Click Run ETL and wait for the process to complete.
SQL Server tip: You may need privileges to create a database. Consult your IT team if required. SQL Server mode is recommended for large schedules and enterprise reporting because it’s faster and more scalable.

4) One-time installation requirements

SQL Server mode (one time):
  • Install SQL Server 2025 (Developer or Express).
  • Install Microsoft ODBC Driver 18 for SQL Server.
  • Ensure you have permission to create a database (ask IT if needed).
SQLite mode (one time):
  • Install an SQLite ODBC driver (for Power BI connectivity via ODBC).
  • Create an ODBC DSN pointing to the generated SQLite database file.
If you don’t have installation privileges on your machine, ask your IT team to install these prerequisites once.

5) Connect the Database to Power BI

SQL Server (recommended):
  1. Open Power BI Desktop.
  2. Go to Get Data → SQL Server.
  3. Enter your Server and Database name.
  4. Choose:
    • Import (recommended for speed)
    • DirectQuery (live connection)
  5. Select the ETL tables (Activities, Relationships, Calendars, Resources, etc.) → click Load.
SQLite (via ODBC):
  1. Open Power BI Desktop.
  2. Go to Get Data → ODBC.
  3. Select your SQLite DSN → choose tables → click Load.
After loading, you can build dashboards such as baseline vs update, critical path, progress trends, delays, S-curves, earned value, and resource analytics.

6) Export Outputs

  1. Use Export Log to save execution logs.
  2. Use Export Data (if available) to export datasets.

Troubleshooting

  • Verification fails: check internet, correct login, and firewall/proxy restrictions.
  • ETL fails: confirm the XER is valid/not corrupted and try a another XER for testing.
  • Power BI can’t connect: check database service is running, credentials, and network access.
Still stuck? Use the form above or email contact@timeimpactai.com.