DGTLMS & LMSDISPATCHER Guide

Tracking & reporting

Connect Power BI (OData feed)

Connect Power BI (or Excel, Tableau) to your DGTLMS data through a standard, read-only OData feed.

Administrator~8 minutesAdvanced
  • The right to administer integrations.
  • A read-only access key (generated in the administration).

Steps

  1. Enable the feed

    Administration → Intégrations & Connecteurs (Integrations & Connectors) → Power BI / OData; generate a dedicated read-only key.

  2. Get the OData URL

    Copy the feed URL provided.

  3. Connect Power BI

    In Power BI: Get data → OData feed, then paste the URL and the key.

  4. Load the model

    Results, time spent and logins come with their dimensions (learners, courses, sessions), typed columns and incremental refresh.

  5. Link the sessions

    To break down your results by session, also load the link table and create two relationships: from sessions to it, then from it to results. The technical guide gives the exact columns.

  • The key is read-only: the analyst sees the data without any right to change it.
  • Linking a result to a session takes into account learners enrolled through a group, and only counts a result in a session if that session actually contains the course concerned.
  • Serve it over HTTPS. A detailed technical guide is available for the IT team.

See also